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

  • From: ryan.gaffuri@xxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 26 Jul 2004 13:50:20 +0000

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

Other related posts: