SQL Scripts to find TEMP tablespace usage

Here are various scripts which helps in determining who's using the TEMP tablespace.

Script 1

select a.inst_id,b.Total_MB, b.Total_MB - round(a.used_blocks*8/1024) Current_Free_MB,        
round(used_blocks*8/1024) Current_Used_MB, round(max_used_blocks*8/1024)             
Max_used_MB from gv$sort_segment a,  
(select round(sum(bytes)/1024/1024) Total_MB from dba_temp_files ) b; 

Script 2

SELECT a.username, a.sid, a.serial#, a.osuser, b.tablespace, b.blocks, c.sql_text
FROM gv$session a, gv$tempseg_usage b, gv$sqlarea c
WHERE a.saddr = b.session_addr
AND c.address= a.sql_address
AND c.hash_value = a.sql_hash_value
ORDER BY b.tablespace, b.blocks

Script 3

select s.sid, s.osuser, s. process, s.sql_id, tmp.segtype, ((tmp.blocks*8)/1024)MB, tmp.tablespace
from gv$tempseg_usage tmp, gv$session s
where tmp.session_num=s.serial# and segtype in ('HASH','SORT')
order by blocks desc;

Script 4

select sql_id,sum(blocks) from gv$tempseg_usage group by sql_id order by 2 desc;

Useful Oracle Notes in reference to TEMP Tablespace

How Can Temporary Segment Usage Be Monitored Over Time? (Doc ID 364417.1)

TROUBLESHOOTING GUIDE (TSG) : ORA-1652: unable to extend temp segment [ID 1267351.1]