patternMinor
I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer
Viewed 0 times
sqltuningtryinggetorawhendeveloperfromadvisor13605
Problem
When trying to use the SQL Tuning Advisor from SQL Developer I get this error.
Tuning advisor was working some days before.
Tuning advisor was working some days before.
Solution
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.
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.
Context
StackExchange Database Administrators Q#2679, answer score: 4
Revisions (0)
No revisions yet.