blog:enabling_oracle_sql_advisor

Enabling Oracle SQL Advisor

This error message from Oracle 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;
  • blog/enabling_oracle_sql_advisor.txt
  • Last modified: 2013/06/10 05:35
  • by brett