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
Other related posts:
