RE: how to get exactly how much temp tablespace a query is using

  • From: Feighery Raymond <Raymond.Feighery@xxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 26 Jul 2004 15:05:18 +0100

select  ss.username,
    su.tablespace,
    su.contents,
    su.extents,
    su.blocks,
        substr(sa.sql_text,1,60)
from v$sort_usage su, v$session ss, v$sqlarea sa
where su.session_addr = ss.saddr
and ss.sql_address = sa.address;

-----Original Message-----
From: ryan.gaffuri@xxxxxxxxxxx [mailto:ryan.gaffuri@xxxxxxxxxxx]
Sent: Monday, July 26, 2004 2:50 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: how to get exactly how much temp tablespace a query is using


query or session level. I had this query in a script on my last project, but
forgot to bring it with me. Now I'm having a brain fart and can't figure out
the joins. I know its v$sort_usage to some where. I think its a 3 table
join. 
Can anyone give it to me? 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: