blog:enabling_oracle_sql_advisor

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revisionBoth sides next revision
blog:enabling_oracle_sql_advisor [2013/04/09 04:13] – brettblog:enabling_oracle_sql_advisor [2013/04/09 05:50] – brett
Line 17: Line 17:
 <code sql> <code sql>
 SQL> alter system set CONTROL_MANAGEMENT_PACK_ACCESS='DIAGNOSTIC+TUNING'; 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> </code>
  
  • blog/enabling_oracle_sql_advisor.txt
  • Last modified: 2013/06/10 05:35
  • by brett