When trying to use the SQL Tuning Advisor from SQL Developer I get this error.
Tuning advisor was working some days before.
I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer
database-tuningoracleoracle-sql-developer
Related Question
- How to get SQL for DDL commands in Sql developer
- ORA-00119 & ORA-00130 when trying to startup Oracle
- Run a script as a sheduled job using sql developer scheduler GUI
- ORA-01017: invalid username/password; logon denied from sql developer but sqlplus logins
- ORA-01017 Invalid Username/Password in SQL Developer
- Oracle: ORA-00942: “table or view does not exist” in SQL Developer
- Cannot connect to 19c with SQL Developer though database is mounted and opened, error ORA-01034
Best Answer
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.