RE: V$SESSION_WAIT FILE# Doesn't Exist?

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Tue, 18 Jan 2011 09:57:32 -0500
Message-ID: <SNT130-ds5AAF36EF08B35611095D5A6F70_at_phx.gbl>

It's reading from temp and it will be a tempfile. Run this to see the sort.  

select

a.tablespace,a.contents,a.extents,a.blocks,b.username,b.osuser, b.sid,

sum(blocks*8192/1024/1024) over () smtot,

sum(blocks*8192/1024/1024) over (partition by sid) sumu

from v$sort_usage a, v$session b

where a.session_addr = b.saddr

order by 9 desc  

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 18 2011 - 08:57:32 CST