SELECT NVL (a.username, 'Null') username, 
          DECODE (a.terminal, '?', 'Detached', a.terminal) terminal,
          a.STATUS, b.object,  b.type, io.BLOCK_GETS,
          io.PHYSICAL_READS, io.BLOCK_CHANGES, 
          s.sql_text  
     FROM v$session a, v$access b, v$sqltext s, V$SESS_Io io 
     where (a.sid = b.sid) and (a.sql_address = s.address) and 
     (a.sql_hash_value = s.hash_value) and (io.sid=a.sid) 
     order by a.username, a.sid, s.piece