blog:enabling_oracle_sql_advisor

This is an old revision of the document!


Enabling Oracle SQL Advisor

This error message from SQL*Developer was bugging the crap out of me

DECLARE
*
ERROR at line 1:
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 651
ORA-06512: at line 4

Turns out the solution is simple

SQL> ALTER system SET CONTROL_MANAGEMENT_PACK_ACCESS='DIAGNOSTIC+TUNING';

Don't forget the grant to your user

SQL> GRANT advisor, administer SQL tuning SET,SELECT any dictionary TO &USER;

~~DISCUSSION~~

  • blog/enabling_oracle_sql_advisor.1365486645.txt.gz
  • Last modified: 2013/04/09 05:50
  • by brett