temp

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 … Read more

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;