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