Home » RDBMS Server » Server Administration » undo & temp tablespace (oracle 10g,Linux)
undo & temp tablespace [message #471071] Thu, 12 August 2010 02:42 Go to next message
rajeshkanna.dba
Messages: 16
Registered: April 2009
Location: Bangalore
Junior Member
Hi guru,

How to check which query is taking more space in temporary tablespace and undo tablespace? (Any dictionary view is there?)
Re: undo & temp tablespace [message #471073 is a reply to message #471071] Thu, 12 August 2010 02:54 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Its a FAQ

Previous Topic: GT Table
Next Topic: ORA-29702 Error
Goto Forum:
  


Current Time: Mon May 20 00:22:20 CDT 2024