We need to resize temp, but trying to resize hangs. Lets see what is using TEMP
SELECT tu.username, s.sid, s.serial#, S.MACHINE, s.inst_id, tu.tablespace FROM gv$tempseg_usage tu, gv$session s WHERE tu.session_addr = s.saddr;
DBSNMP 1715 99 myhost 1 TEMP2
You can either wait for the sessions to complete or in my case, it was the agent that was accessing it so we can kill it.
alter system kill session '1715,99' immediate;