SQL Developer

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!

Error when using SQL Tuning Advisor

1004629Mar 12 2014 — edited Mar 12 2014

I'm trying to use the SQL Tuning Advisor in sqldeveloper, but it fails.

The latest query I'm trying to analyze is just a simple SELECT * from XX.

I get the error below and don't know how to fix.

Any help?

An error was encountered performing the requested operation:

ORA-13605: The specified task or object staName55422 does not exist for the current user.

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

ORA-06512: at "SYS.PRVT_ADVISOR", line 5878

ORA-06512: at "SYS.DBMS_SQLTUNE", line 926

ORA-06512: at line 2

13605. 00000 - "The specified task or object %s does not exist for the current user."

*Cause: The user attempted to reference an advisor task or object

using a name that does not exist in the Advisor repository.

*Action: Adjust the name and retry the operation.

Vendor code 13605

This post has been answered by 1004629 on Mar 12 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2014

Added on Mar 12 2014

#sql-developer

2 comments

2,518 views