Find the sessions using the default temporary tablespace.
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;
Find the sessions using the default temporary tablespace.
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;