Oracle-L: RE: Who is using temp tablespace?

From: Satav, Pawan <pawan.satav_at_cgey.com>
Date: Tue, 04 Nov 2003 05:29:24 -0800
Message-ID: <F001.005D58B8.20031104052924@fatcity.com>

v$sort_usage and v$session should give you that.

Pawan
-----Original Message-----
Sent: Tuesday, November 04, 2003 6:49 PM To: Multiple recipients of list ORACLE-L

Hi All,

How can I determine who is using temp tablespace? I have a 1 gb tablespace and it is almost full. I want to know who and what sql is using most of it.

Thanks
Rick

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Rick_Cale_at_teamhealth.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorised to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Satav, Pawan
INET: pawan.satav_at_cgey.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------