/*
SQL> desc v$sort_usage
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 USERNAME                                           VARCHAR2(30)
 USER                                               VARCHAR2(30)
 SESSION_ADDR                                       RAW(8)
 SESSION_NUM                                        NUMBER
 SQLADDR                                            RAW(8)
 SQLHASH                                            NUMBER
 TABLESPACE                                         VARCHAR2(31)
 CONTENTS                                           VARCHAR2(9)
 SEGTYPE                                            VARCHAR2(9)
 SEGFILE#                                           NUMBER
 SEGBLK#                                            NUMBER
 EXTENTS                                            NUMBER
 BLOCKS                                             NUMBER
 SEGRFNO#                                           NUMBER
*/


column event format a20
column p1 format 99999999
column p2 format 99999999
column p3 format 9999
Select s.sid,
       --su.USERNAME ,
       -- su.CONTENTS,
       su.SEGTYPE ,
       su.SQLHASH ,
       su.extents,
       su.blocks,
       -- s.SQL_HASH_VALUE ,
       substr(sw.event,1,20) event
       -- , sw.p1 p1 ,sw.p2 p2 ,sw.p3 p3
from v$sort_usage su,
     v$session s,
     v$session_wait sw
Where
    s.sid = sw.sid and
    s.saddr = su.session_addr and
    s.serial# = su .session_num;