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

From: Feighery Raymond <Raymond.Feighery_at_churchill.com>
Date: Mon, 26 Jul 2004 15:05:18 +0100
Message-ID: <817D2444710B934B9F7B8A1DAAF432D601F2AF70@brcexm03>

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_at_comcast.net [mailto:ryan.gaffuri_at_comcast.net] Sent: Monday, July 26, 2004 2:50 PM
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://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_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Jul 26 2004 - 09:02:24 CDT