Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-13780

lesakJun 4 2010 — edited Jun 4 2010

I have problem with Oracle Advisor. After executing some tune queries I can see sql_id via this statement:

SELECT sql_id, sql_text FROM v$sql WHERE sql_text like '%my_test_query%';

But when I run dbms_sqltune.create_tuning_task package directly after query paste above - Oracle give me such errors:

ERROR at line 1:
ORA-13780: SQL statement does not exist.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_SQLTUNE", line 784
ORA-06512: at line 8

It's happen only today - yesterday I run those statements and everything was OK. Could anyone explain me what's happen and how to resolve the problem?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 2 2010

Added on Jun 4 2010

#general-database-discussions

8 comments

2,109 views