Sessions using temp

--- sessions using temp

col user for a15
col OSUSER for a15
col unix_pid for a10
col program for a20 trun
col MACHINE for a30 trunc
col SQL_TEXT for a60 trunc
 col TABLESPACE for a20
compute sum of mb_temp_used on tablespace

select * from (
select distinct
   c.username "user",
   c.osuser,
   c.sid,
   c.serial#,
   b.spid "unix_pid",
   c.machine,
   c.program "program",
   a.blocks * e.block_size/1024/1024 mb_temp_used  ,
   a.tablespace,
   d.sql_text
from
   gv$sort_usage a,
   gv$process b,
   gv$session c,
   gv$sqlarea d,
   dba_tablespaces e
where
   c.saddr=a.session_addr
and
   b.addr=c.paddr
and
   c.sql_address=d.address(+)
and
   a.tablespace = e.tablespace_name
and (a.blocks * e.block_size/1024/1024) > 10
order by MB_TEMP_USED desc
);