Cannot drop sql tuning set: ORA-13757: "SQL Tuning Set" owned by user is active
Hi
Oracle 12.1.0.2.0 and 19.6
I cannot seem to drop any of these sql tuning sets, that are created by SQL Tuning Advisor (task name starts with SQL_TUNING_...)
select ss.*, ssr.created, ssr.description from dba_sqlset ssinner join dba_sqlset_references ssr on ss.id = ssr.sqlset_idwhere rownum < 2;
SQL> select * from dba_advisor_tasks where task_name = 'SQL_TUNING_1349683748244';no rows selected
Why can't I drop this..?
SQL> exec dbms_sqltune.drop_sqlset(sqlset_name => 'TOP_SQL_1349683747766', sqlset_owner => 'SYSTEM');BEGIN dbms_sqltune.drop_sqlset(sqlset_name => 'TOP_SQL_1349683747766', sqlset_owner => 'SYSTEM'); END;*ERROR at line 1:ORA-13757: "SQL Tuning Set" "TOP_SQL_1349683747766" owned by user "SYSTEM" is active.ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 14910ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 17745ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 14881ORA-06512: at "SYS.DBMS_SQLTUNE", line 7315ORA-06512: at line 1
2