I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer

Question

When trying to use the SQL Tuning Advisor from SQL Developer I get this error.

Tuning advisor was working some days before.

enter image description here

You get this no matter what the SQL? Have you tried a different user? — Jack Douglas, May 12, 2011 at 18:13
I tried this in different VMs and with different users. It works sometimes, but after analyzing some long query I get the problem. — bernd_k, May 13, 2011 at 5:10

bernd_k · Accepted Answer · 2011-05-16 09:56:23Z

4

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.

answered May 16, 2011 at 9:56

bernd_k

12.1k23 gold badges74 silver badges110 bronze badges

How long is too long - are you hitting the 32K limit for Native Dynamic SQL?
– Jack Douglas
May 16, 2011 at 11:23
The true sql statement is tuned to be less than 4000 char. It has to run on 10g. But printed to output and coped to a file it got 415 KB due to trailing blanks.
– bernd_k
May 16, 2011 at 12:40
wow, that is a lot of blanks :) well spotted.
– Jack Douglas
May 16, 2011 at 12:57

Add a comment |

Mat · Accepted Answer · 2012-11-03 17:46:00Z

0

Try to switch your browser's language settings.

If the database is running with American/America, switch your browser to en-us. Then re-connect and run the task again.

This fixed up our SQL Tuning Advisor task which failed with the same error.

Mat

9,9494 gold badges42 silver badges40 bronze badges

answered Apr 2, 2012 at 11:58

Alexander Wiese

1

Add a comment |

2 Answers 2