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?
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 · Accepted Answer · 2011-05-16 09:56:23Z

up vote 3 down vote accepted

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 '11 at 9:56

bernd_k
3,77332161

	How long is too long - are you hitting the 32K limit for Native Dynamic SQL? – Jack Douglas♦ May 16 '11 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 '11 at 12:40
	wow, that is a lot of blanks :) well spotted. – Jack Douglas♦ May 16 '11 at 12:57

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

up vote 0 down vote

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.

edited Nov 3 '12 at 17:46

Mat
3,3401621

answered Apr 2 '12 at 11:58

Alexander Wiese
1

2 Answers