Home » RDBMS Server » Server Administration » About Temporary Tablespace Contents. (Oracle 10.2.0.2, solaris)
About Temporary Tablespace Contents. [message #318474] Wed, 07 May 2008 00:14 Go to next message
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
Member
Can I see the current contents of the temporary tablespace.

I want to know which operation is now going inside temporary tablespace.

Is there nay way to know?
Re: About Temporary Tablespace Contents. [message #318504 is a reply to message #318474] Wed, 07 May 2008 01:05 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, there is no way to see the content of a temporary tablespace.
But you can have an estimation querying V$TEMPSEG_USAGE and joining it with other views (v$session, v$sql...).

Regards
Michel
Previous Topic: Connecting to another Oracle Server
Next Topic: its the error
Goto Forum:
  


Current Time: Fri Dec 09 00:05:35 CST 2016

Total time taken to generate the page: 0.09452 seconds