When trying to use the SQL Tuning Advisor from SQL Developer I get this error.
Tuning advisor was working some days before.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
The solution is very simple. The string of the query is just too long.
I'm trying to optimize a stored procedure using dynamic sql with a parameter to decide if the sql is executed or output.
I just copied the output into a fresh sql developer pane and tried to use the tuning advisor.
The problem is that the generated output has a lot of trailing blanks, I just have to remove them.