Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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: 30
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: 15243
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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:killed session still in v$session but not in v$process
Next Topic:how many instances can be run in one server?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 01:21:59 CDT 2008

Total time taken to generate the page: 0.07442 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.