Finding query with high temp space usage using ASH views



select se.username,se.sid,sum(tu.blocks)*8192 from v$tempseg_usage tu,v$session se where
 tu.session_addr=se.saddr and tu.session_num=se.serial#
group by se.sid,se.username order by se.sid;