Home » RDBMS Server » Server Administration » About Temporary Tablespace Contents. (Oracle, solaris)
About Temporary Tablespace Contents. [message #318474] Wed, 07 May 2008 00:14 Go to next message
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
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: 63911
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...).

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

Current Time: Sat Oct 22 21:19:47 CDT 2016

Total time taken to generate the page: 0.04454 seconds