/* Formatted on 11/13/2020 6:00:09 PM (QP5 v5.360) */
SELECT *
  FROM (  SELECT B.SID
                     SID,
                 DECODE (B.USERNAME, NULL, E.NAME, B.USERNAME)
                     USER_NAME,
                 D.SPID
                     OS_ID,
                 B.MACHINE
                     MACHINE_NAME,
                 TO_CHAR (LOGON_TIME, 'DD-MON-YY HH:MI:SS PM')
                     LOGON_TIME,
                 (  SUM (
                        DECODE (C.NAME,
                                'PHYSICAL READS E "PHYSICAL READS" ', VALUE,
                                0))
                  + SUM (DECODE (C.NAME, 'PHYSICAL WRITES', VALUE, 0))
                  + SUM (DECODE (C.NAME, 'PHYSICAL WRITES DIRECT', VALUE, 0))
                  + SUM (
                        DECODE (C.NAME,
                                'PHYSICAL WRITES DIRECT (LOB)', VALUE,
                                0))
                  + SUM (
                        DECODE (
                            C.NAME,
                            'PHYSICAL READS E "PHYSICAL READS"  DIRECT (LOB)', VALUE,
                            0))
                  + SUM (
                        DECODE (
                            C.NAME,
                            'PHYSICAL READS E "PHYSICAL READS"  DIRECT', VALUE,
                            0)))
                     TOTAL_PHYSICAL_IO,
                 (  SUM (DECODE (C.NAME, 'DB BLOCK GETS', VALUE, 0))
                  + SUM (DECODE (C.NAME, 'DB BLOCK CHANGES', VALUE, 0))
                  + SUM (DECODE (C.NAME, 'CONSISTENT CHANGES', VALUE, 0))
                  + SUM (
                        DECODE (C.NAME,
                                'CONSISTENT GETS E "CONSISTENT GETS" ', VALUE,
                                0)))
                     TOTAL_LOGICAL_IO,
                 (  SUM (DECODE (C.NAME, 'SESSION PGA MEMORY', VALUE, 0))
                  + SUM (DECODE (C.NAME, 'SESSION UGA MEMORY', VALUE, 0)))
                     TOTAL_MEMORY_USAGE,
                 SUM (DECODE (C.NAME, 'PARSE COUNT (TOTAL)', VALUE, 0))
                     PARSES,
                 SUM (DECODE (C.NAME, 'CPU USED BY THIS SESSION', VALUE, 0))
                     TOTAL_CPU,
                 SUM (DECODE (C.NAME, 'PARSE TIME CPU', VALUE, 0))
                     PARSE_CPU,
                 SUM (DECODE (C.NAME, 'RECURSIVE CPU USAGE', VALUE, 0))
                     RECURSIVE_CPU,
                   SUM (DECODE (C.NAME, 'CPU USED BY THIS SESSION', VALUE, 0))
                 - SUM (DECODE (C.NAME, 'PARSE TIME CPU', VALUE, 0))
                 - SUM (DECODE (C.NAME, 'RECURSIVE CPU USAGE', VALUE, 0))
                     OTHER_CPU,
                 SUM (DECODE (C.NAME, 'SORTS (DISK)', VALUE, 0))
                     DISK_SORTS,
                 SUM (DECODE (C.NAME, 'SORTS (MEMORY)', VALUE, 0))
                     MEMORY_SORTS,
                 SUM (DECODE (C.NAME, 'SORTS (ROWS)', VALUE, 0))
                     ROWS_SORTED,
                 SUM (DECODE (C.NAME, 'USER COMMITS', VALUE, 0))
                     COMMITS,
                 SUM (DECODE (C.NAME, 'USER ROLLBACKS', VALUE, 0))
                     ROLLBACKS,
                 SUM (DECODE (C.NAME, 'EXECUTE COUNT', VALUE, 0))
                     EXECUTIONS
            FROM SYS.V_$SESSTAT  A,
                 SYS.V_$SESSION  B,
                 SYS.V_$STATNAME C,
                 SYS.V_$PROCESS  D,
                 SYS.V_$BGPROCESS E
           WHERE     A.STATISTIC# = C.STATISTIC#
                 AND B.SID = A.SID
                 AND D.ADDR = B.PADDR
                 AND E.PADDR(+) = B.PADDR
                 AND C.NAME IN ('USER COMMITS')
        GROUP BY B.SID,
                 D.SPID,
                 DECODE (B.USERNAME, NULL, E.NAME, B.USERNAME),
                 B.MACHINE,
                 TO_CHAR (LOGON_TIME, 'DD-MON-YY HH:MI:SS PM')
        ORDER BY 6 DESC)
 WHERE ROWNUM < 21;