Robin Moffatt 3/9/2010

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

Read Original

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.

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

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
The Beautiful Web
Jens Oliver Meiert 2 votes
2
Container queries are rad AF!
Chris Ferdinandi 2 votes
3
Wagon’s algorithm in Python
John D. Cook 1 votes
5
Top picks — 2026 January
Paweł Grzybek 1 votes
6
In Praise of –dry-run
Henrik Warne 1 votes
8
Vibe coding your first iOS app
William Denniss 1 votes