DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, March 23, 2016

           
               Enabling Automated SQL Tuning in Oracle 11g


You need to identify if Automatic SQL Tuning job is enabled and regularly running. Use the following query to determine if any Automatic SQL Tuning jobs are enabled:

Use the following query:

SELECT client_name, status, consumer_group, window_group FROM dba_autotask_client ORDER BY client_name;




To enable the sql tuning advisor sue the following procedure 
----------------------------------------------------------------------------
BEGIN 
DBMS_AUTO_TASK_ADMIN.ENABLE( 
client_name => 'sql tuning advisor', 
operation => NULL, 
window_name => NULL); 
END; 

And check now with the same query to cross check.

SELECT client_name, status, consumer_group, window_group FROM dba_autotask_client ORDER BY client_name;


No comments: