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?

Report message to a moderator

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: 68675
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 06 16:35:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.