ORACLE 关闭sql tuner

 

1.    查询STA状态，可通过如下语句：

select currently_used from dba_feature_usage_statistics where name ='SQL Tuning Advisor';       或
       select status from DBA_AUTOTASK_CLIENT t where t.client_name='sql tuning advisor'

2.    关闭STA

BEGIN

DBMS_AUTO_TASK_ADMIN.DISABLE(

client_name => 'sql tuning advisor',

operation => NULL,

window_name => NULL);

END;

/