Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
blog:enabling_oracle_sql_advisor [2013/04/09 04:13] – brett | blog:enabling_oracle_sql_advisor [2013/06/10 05:35] (current) – [Enabling Oracle SQL Advisor] 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 19: | Line 19: | ||
</ | </ | ||
- | {{tag>oracle}} | + | Don't forget the grant to your user |
+ | <code sql> | ||
+ | SQL> grant advisor, administer sql tuning set,select any dictionary to & | ||
+ | </code> | ||
+ | {{tag> | ||
- | ~~DISCUSSION~~ | ||