Home » RDBMS Server » Performance Tuning » TEMP Space used by each user - HOWTO?
TEMP Space used by each user - HOWTO? [message #65069] Wed, 14 April 2004 17:06 Go to next message
IA
Messages: 91
Registered: March 2004
Member
Hi Everyone,

I am running on Oracle 8i (8.1.7).
I would like a query that identifies how much temp space each user on the system is using.

Can anyone help ... Thanks IA.
Re: TEMP Space used by each user - HOWTO? [message #65070 is a reply to message #65069] Wed, 14 April 2004 20:41 Go to previous message
ora9iDBA
Messages: 31
Registered: March 2003
Member
v$sort_usage
Previous Topic: PROBLE IN ANALYZE
Next Topic: Querying a Partitioned table
Goto Forum:
  


Current Time: Tue Nov 26 11:20:55 CST 2024