11g - SQL Access Advisor:
DEMO DEMO DEMO DEMO DEMO DEMO DEMO
Make sure that the user SH has been granted the following privileges.
SQL> sho user
USER is "SYS"
SQL> grant all on dbms_advisor to sh;
SQL> grant advisor to sh;
SQL> grant ADMINISTER SQL TUNING SET to sh;
Scripts used :
SQL Access Recommendations :
11g - SQL Access Advisor