OraFAQ Forum: Server Administration » Disabling SQL Tuning Advisor

Home » RDBMS Server » Server Administration » Disabling SQL Tuning Advisor (oracle 10.2.0.4 - Windows server 2003)

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

Disabling SQL Tuning Advisor [message #602526]

Thu, 05 December 2013 04:49

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi,

Is there any way to disable the SQL Tuning Advisor in 10g like we have in 11g as below.

BEGIN
  DBMS_AUTO_TASK_ADMIN.DISABLE(
    client_name => 'sql tuning advisor', 
    operation => NULL, 
    window_name => NULL);
END;

Regards
Muktha

Report message to a moderator

Re: Disabling SQL Tuning Advisor [message #602530 is a reply to message #602526]

Thu, 05 December 2013 06:36

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

Did you look at the manuals?

I found after a little search : this.
Be aware : this is oracle 11.1 documentation, but I'm quite sure that this will work in 11.2

Report message to a moderator

Re: Disabling SQL Tuning Advisor [message #602535 is a reply to message #602530]

Thu, 05 December 2013 07:13

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

martijn wrote on Thu, 05 December 2013 12:36

but I'm quite sure that this will work in 11.2

Although, of course, the OP is asking about the option in 10g...

Report message to a moderator

Re: Disabling SQL Tuning Advisor [message #602537 is a reply to message #602535]

Thu, 05 December 2013 07:23

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

pablolee wrote on Thu, 05 December 2013 14:13

martijn wrote on Thu, 05 December 2013 12:36
but I'm quite sure that this will work in 11.2

Although, of course, the OP is asking about the option in 10g...

Ow...how stupid (of me).

Reading seems to be very difficult at times.

Sorry for the noise

Report message to a moderator

Re: Disabling SQL Tuning Advisor [message #602538 is a reply to message #602526]

Thu, 05 December 2013 07:27

John Watson
Messages: 8966
Registered: January 2010
Location: Global Village

Senior Member

muktha_22 wrote on Thu, 05 December 2013 10:49

Hi,

Is there any way to disable the SQL Tuning Advisor in 10g like we have in 11g as below.
BEGIN
  DBMS_AUTO_TASK_ADMIN.DISABLE(
    client_name => 'sql tuning advisor', 
    operation => NULL, 
    window_name => NULL);
END;
Regards
Muktha

This does not disable the SQL Tuning Advisor, all it does is disable the autotask that runs the advisor in every maintenance window. To disable it in 11.x you have the control_management_pack_access parameter. No way I know of in 10.x

Report message to a moderator

Re: Disabling SQL Tuning Advisor [message #602539 is a reply to message #602537]

Thu, 05 December 2013 07:31

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

martijn wrote on Thu, 05 December 2013 13:23

Reading seems to be very difficult at times.

Sorry for the noise

LOL, I know exactly what you mean. No apologies necessary.

Report message to a moderator

Re: Disabling SQL Tuning Advisor [message #602605 is a reply to message #602539]

Thu, 05 December 2013 22:49

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Thanks for all of you for great support.

But can any one tell me, how to find out the processes, which are using the SQL TUNING ADVISOR feature.

Regards
Muktha

[Updated on: Fri, 06 December 2013 07:18]

Report message to a moderator

Previous Topic:	Query hidden parameters
Next Topic:	Kick out users on 10g?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 05 12:04:31 CST 2025