OraFAQ Forum: General

Home » Other » General » ts$

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ts$ [message #236379]

Wed, 09 May 2007 15:09

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

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

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

Michel Cadot
Messages: 68643
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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 04:01:46 CDT 2024