RE: How to identify Temp Space being used

From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
To: <oratips@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 4 Apr 2007 16:50:55 -0400

You don't mention a version, but, if it's relatively recent, then this:
select * from v$sort_usage;
should tell you what you want to know.
 
-Mark
 

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest/CSA 

"There are 10 types of people in the world:  Those who understand
binary, and those who don't." 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bala
Sent: Wednesday, April 04, 2007 1:46 PM
To: oracle-l
Subject: How to identify Temp Space being used


Can anyone share the sql to identify the Temp space being used by the
currently running SQL in database  
 
Thanks much.

-- 
Bala Rao

References:

How to identify Temp Space being used
From: Bala

RE: How to identify Temp Space being used

Other related posts: