Monday, 2 November 2015

Who is using temp with login id and SID

select u.tablespace
       , u.segfile#
       , u.segblk#
       , u.blocks
       , s.sid
       , s.serial#
--       , p.spid
       , s.username
       , s.osuser
       , s.status
from v$session s
   , v$sort_usage u
   , v$process p
where s.saddr = u.session_addr
  and s.paddr = p.addr
order by u.blocks desc;

No comments:

Post a Comment