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!

Tuning Advisor doesn't work: ORA-13605, ORA-06512,

1046786Jan 23 2014 — edited Jan 23 2014

I'm trying to use SQL Tuning Advisor with the query: select * from MYTABLE; but I got the following errors.

Nothing changes if I switch from custom user to admin user.

I'm using Oracle SQL Developer 4.0.0.13.80 and Oracle XE 11g

ORA-13605: The specified task or object staName30874 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.

Codice fornitore 13605

ORA-13717: Tuning Package License is needed for using this feature.

ORA-06512: at "SYS.PRVT_SMGUTIL", line 52

ORA-06512: at "SYS.PRVT_SMGUTIL", line 37

ORA-06512: at "SYS.DBMS_MANAGEMENT_PACKS", line 26

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

ORA-06512: at line 5

Any help?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2014

Added on Jan 23 2014

#exception, #sql-developer

7 comments

3,191 views