Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> how to get exactly how much temp tablespace a query is using

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

From: <ryan.gaffuri_at_comcast.net>
Date: Mon, 26 Jul 2004 13:50:20 +0000
Message-Id: <072620041350.9053.41050C1C000235C00000235D2200762302079D9A00000E09D2020E979D@comcast.net>


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
Received on Mon Jul 26 2004 - 08:46:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US