Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== Enabling Oracle SQL Advisor ====== This error message from Oracle SQL Developer was bugging the crap out of me <code> 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 </code> Turns out the solution is simple <code sql> SQL> alter system set CONTROL_MANAGEMENT_PACK_ACCESS='DIAGNOSTIC+TUNING'; </code> Don't forget the grant to your user <code sql> SQL> grant advisor, administer sql tuning set,select any dictionary to &USER; </code> {{tag>oracle}} blog/enabling_oracle_sql_advisor.txt Last modified: 2013/06/10 05:35by brett