Sorts - show current sorts and the associated SQL and session
-- @sort_usage.sql
set head on
set verify off
set echo off
set trimspool on
set pagesize 500
set linesize 130 
column sqlhash format 9999999999

select /*+ ORDERED */ a.*, s.username, s.osuser, s.sid, s.serial#, s.client_info, b.sql_text
from v$sort_usage a, v$session s, v$sqlarea  b
where a.extents > 10 
and s.sql_address = b.address
and a.session_addr = s.saddr