Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revisionLast revisionBoth sides next revision | ||
blog:enabling_oracle_sql_advisor [2013/04/09 04:13] – brett | blog:enabling_oracle_sql_advisor [2013/04/09 05:51] – brett | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Enabling Oracle SQL Advisor ====== | ====== Enabling Oracle SQL Advisor ====== | ||
- | This error message from SQL*Developer was bugging the crap out of me | + | This error message from Oracle |
- | < | + | < |
DECLARE | DECLARE | ||
* | * | ||
Line 17: | Line 17: | ||
<code sql> | <code sql> | ||
SQL> alter system set CONTROL_MANAGEMENT_PACK_ACCESS=' | SQL> alter system set CONTROL_MANAGEMENT_PACK_ACCESS=' | ||
+ | </ | ||
+ | |||
+ | Don't forget the grant to your user | ||
+ | <code sql> | ||
+ | SQL> grant advisor, administer sql tuning set,select any dictionary to &USER; | ||
</ | </ | ||