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

From: Naveen, Nahata (IE10) <Naveen.Nahata_at_honeywell.com>
Date: Thu, 13 May 2004 05:11:17 -0700
Message-ID: <77ED2BF75D59D1439F90412CC5B109740BD5E849@ie10-sahara.hiso.honeywell.com>

i think v$sort_usage will help you.

Regards
Naveen

>-----Original Message-----
>From: ryan.gaffuri_at_cox.net [mailto:ryan.gaffuri_at_cox.net]
>Sent: Thursday, May 13, 2004 4:52 PM
>To: oracle-l_at_freelists.org
>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_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 Thu May 13 2004 - 07:06:15 CDT