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.

Report message to a moderator

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: 4963
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?

Report message to a moderator

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?

Report message to a moderator

Re: ts$ [message #236479 is a reply to message #236379] Thu, 10 May 2007 01:29 Go to previous message
Michel Cadot
Messages: 68786
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 05 15:13:09 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.