Home » Other » General » ts$
ts$ [message #236379] Wed, 09 May 2007 15:09 Go to next message
joau_hk
Messages: 4
Registered: May 2007
Junior Member
Hi,

Does anyone know what is the below SQL used for and is it ok to disable, how?

select min(bitmapped) from ts$ where dflmaxext =:1 and bitand(flags,1024) =1024

Thanks.
Re: ts$ [message #236381 is a reply to message #236379] Wed, 09 May 2007 15:17 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
You got this from V$SQL assume.
Oracle is internally running this. Why do you want to disable it?
Re: ts$ [message #236389 is a reply to message #236381] Wed, 09 May 2007 15:38 Go to previous messageGo to next message
joau_hk
Messages: 4
Registered: May 2007
Junior Member
It's using a lot of CPU and I wonder what's it for?
Re: ts$ [message #236479 is a reply to message #236379] Thu, 10 May 2007 01:29 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The only way to "disable" it is to not use tablespace group.
Use standard temporary tablespace and not global temporary tablespace.

The other way is to apply patch 5455880.

Regards
Michel
Previous Topic: free NFR licenses for Oracle ACEs
Next Topic: Slighty OT:Perspective on Referential Integrity & other DB integrity constraints
Goto Forum:
  


Current Time: Thu Dec 08 12:32:56 CST 2016

Total time taken to generate the page: 0.10287 seconds