Database Tuning (MOSC)

MOSC Banner

Cannot drop sql tuning set: ORA-13757: "SQL Tuning Set" owned by user is active

edited Feb 18, 2020 12:51PM in Database Tuning (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center