RE: How to identify Temp Space being used

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 04 2007 - 15:50:55 CDT