View sorts per user session

Run this query to see sorts per user session. Replace BLOCKSIZE with block size for your
database i.e. if it's 8Kb replace it with 8192

SELECT s.username
        ,s.sid
        ,s.serial#
        ,u.SESSION_ADDR 
        ,u.contents 
        ,u.TABLESPACE 
        ,u.BLOCKS
        ,round(u.BLOCKS*BLOCKSIZE/1024/1024,1) as MBS
        ,u.EXTENTS
        ,u.SEGFILE# 
        ,u.SEGBLK# 
        ,u.SEGRFNO#
        ,u.SEGTYPE 
        ,u.SQLADDR
        ,u.SQLHASH
FROM v$session s
        , v$sort_usage u 
WHERE s.saddr = u.session_addr
/