f 無法drop STS(SQL Tuing Set) ~ 迪貝之家

無法drop STS(SQL Tuing Set)

 

ORA-13757: “SQL Tuning Set” “string” owned by user “string” is active.
主因是該STS 被你拿來建了一個Tuning Task

 

1.先去找dba_advisor_log找到可能的task,drop 它
select * from user_advisor_log;

 

drop tuning task的語法
exec DBMS_SQLTUNE.DROP_TUNING_TASK('SQLACCESS3638400');

 

2.然後再到user_sqlset找STS 的資料,drop 它
select * from user_sqlset;

 

drop STS 的語法
exec DBMS_SQLTUNE.DROP_SQLSET(sqlset_name => 'SQLACCESS3638400_sts');