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;
, 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