Robin Moffatt • 3/9/2010

ORA-13757: "SQL Tuning Set" "string" owned by user "string" is active.

This technical article explains the ORA-13757 error encountered when trying to delete an active SQL Tuning Set in Oracle. It provides step-by-step SQL queries to identify the root cause—often a stale SQL Tuning Advisor task—and demonstrates how to properly drop the referencing task and then the tuning set using DBMS_SQLTUNE procedures.

0 comments

#error handling #database #oracle