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;
/