SELECT a.Sid "-Id"
     , a.Serial# "-Serial#"
     , a.SchemaName "Schema"
     , a.Status "Status"
     , a.Server "Server"
     , a.OsUser "Osuser"
     , a.Machine "Machine"
     , a.Program "Program"
     , a.Type "Type"
     , a.Module "Module"
     , a.Action "Action"
     , a.Client_Info "Client Info"
     , b.Block_Gets "-Block Gets"
     , b.Consistent_Gets "-Consistent Gets"
     , b.Physical_Reads "-Physical Reads"
     , b.Block_Changes "-Block Changes"
     , b.Consistent_Changes "-Consistent Changes"
     , c.Value * 10 "-CPU (ms)"
     , a.last_call_et "Last SQL"
     , a.Process "-Client PID"
     , e.SPid "-Server PID"
     , d.sql_text "Current statement"
     , a.SQL_Address || ':' || a.SQL_Hash_Value " SQL Address"
     , a.Prev_SQL_Addr || ':' || a.Prev_Hash_Value " Prev SQl Address"
  FROM v$session a
     , v$sess_io b
     , v$sesstat c
     , v$sql d
     , v$process e
 WHERE a.sid = b.sid ( + )
   AND a.sid = c.sid ( + )
   AND ( c.statistic# = 12 OR c.statistic# IS NULL )
   AND a.sql_address = d.address ( + )
   AND a.sql_hash_value = d.hash_value ( + )
   AND ( d.child_number = 0 OR d.child_number IS NULL )
   AND a.paddr = e.addr ( + )
   AND a.Type != 'BACKGROUND'
   AND a.Status != 'INACTIVE'
 ORDER BY a.Sid