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@freelists.org [mailto:oracle-l-bounce@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

RE: How to identify Temp Space being used

Bobak, Mark

2007-04-04