RE: how to find out how much temp space a session is using?

  • From: "Naveen, Nahata (IE10)" <Naveen.Nahata@xxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 13 May 2004 05:11:17 -0700

i think v$sort_usage will help you.

Regards
Naveen

>-----Original Message-----
>From: ryan.gaffuri@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx]
>Sent: Thursday, May 13, 2004 4:52 PM
>To: oracle-l@xxxxxxxxxxxxx
>Subject: how to find out how much temp space a session is using?
>
>
>I checked v$tempfile, I didn't see it. Anyway to check? 
>
>----------------------------------------------------------------
>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: