Home » RDBMS Server » Server Administration » Disabling SQL Tuning Advisor (oracle 10.2.0.4 - Windows server 2003)
Disabling SQL Tuning Advisor [message #602526] Thu, 05 December 2013 04:49 Go to next message
muktha_22
Messages: 526
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
Re: Disabling SQL Tuning Advisor [message #602530 is a reply to message #602526] Thu, 05 December 2013 06:36 Go to previous messageGo to next message
martijn
Messages: 283
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
Re: Disabling SQL Tuning Advisor [message #602535 is a reply to message #602530] Thu, 05 December 2013 07:13 Go to previous messageGo to next message
pablolee
Messages: 2870
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...
Re: Disabling SQL Tuning Advisor [message #602537 is a reply to message #602535] Thu, 05 December 2013 07:23 Go to previous messageGo to next message
martijn
Messages: 283
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
Re: Disabling SQL Tuning Advisor [message #602538 is a reply to message #602526] Thu, 05 December 2013 07:27 Go to previous messageGo to next message
John Watson
Messages: 7608
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


Re: Disabling SQL Tuning Advisor [message #602539 is a reply to message #602537] Thu, 05 December 2013 07:31 Go to previous messageGo to next message
pablolee
Messages: 2870
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.
Re: Disabling SQL Tuning Advisor [message #602605 is a reply to message #602539] Thu, 05 December 2013 22:49 Go to previous message
muktha_22
Messages: 526
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:
  


Current Time: Mon Oct 15 14:40:35 CDT 2018