SELECT SUBSTR(V$SESSION.USERNAME, 1, 8) USERNAME,
       V$SESSION.OSUSER OSUSER,
       V$SQLAREA.DISK_READS DISK_READS,
       V$SQLAREA.BUFFER_GETS BUFFER_GETS,
       SUBSTR(V$SESSION.LOCKWAIT, 1, 10) LOCKWAIT,
       V$SESSION.PROCESS PID,
       V$SESSION_WAIT.EVENT EVENT,
       V$SQLAREA.SQL_TEXT SQL,
       V$SQLAREA.SQL_FULLTEXT SQL_FULL
  FROM V$SESSION_WAIT, V$SQLAREA, V$SESSION
 WHERE V$SESSION.SQL_ADDRESS = V$SQLAREA.ADDRESS
   AND V$SESSION.SQL_HASH_VALUE = V$SQLAREA.HASH_VALUE
   AND V$SESSION.SID = V$SESSION_WAIT.SID(+)
   AND V$SESSION.STATUS = 'ACTIVE'
   AND V$SESSION_WAIT.EVENT != 'client message'
 ORDER BY V$SESSION.LOCKWAIT ASC, V$SESSION.USERNAME;