Check the temporary tablespace usage

column sid_serial format A12 heading “Sid-Serial”
column tablespace format a15 heading ‘TBS Name’
column spid format 9,999 heading ‘Unix ID’
column segblk# format 999,999,999 heading ‘Block ID’
column size_mb format 999,990 heading “MBytes Used”
column username format a10 heading “DB User”
column osuser format a20 heading “OS User”
column program format a35

select s.sid ||’,’|| s.serial# sid_serial,c.SPID spid, s.status,
s.username, s.osuser, s.program, su.tablespace, round(((su.blocks * p.value)/(1024*1024))) size_mb
from v$session s, v$sort_usage su, v$process c, v$parameter p where p.name=’db_block_size’
and s.saddr = su.session_addr and s.paddr = c.addr
order by 8 desc;