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');