What is using 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 that was accessing it so we can kill it.

alter system kill session '1715,99' immediate;

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.