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.

0 comments
#error handling #database #oracle
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
When your coding agent doesn’t understand your project, you’ll get junk
Benjamin Cane • 1 votes
3
LLM Use in the Python Source Code
Miguel Grinberg • 1 votes
4
Wagon’s algorithm in Python
John D. Cook • 1 votes
5
An example conversation with Claude Code
Dumm Zeuch • 1 votes