Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next 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 2: | Line 2: | ||
This error message from SQL*Developer was bugging the crap out of me | This error message from SQL*Developer was bugging the crap out of me | ||
- | < | + | < |
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; | ||
</ | </ | ||