Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionLast revisionBoth sides next revision | ||
blog:enabling_oracle_sql_advisor [2013/04/09 04:13] – created 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 19: | Line 19: | ||
</ | </ | ||
- | {{tag>}} | + | Don't forget the grant to your user |
+ | <code sql> | ||
+ | SQL> grant advisor, administer sql tuning set,select any dictionary to & | ||
+ | </ | ||
+ | |||
+ | {{tag>oracle}} | ||
~~DISCUSSION~~ | ~~DISCUSSION~~ | ||