How Oracle APEX

by: Amr Abdeen

How to use the SQL Tuning Advisor feature in Oracle SQL Developer

by · Published · Updated

First execute some codes ..

ALTER system SET CONTROL_MANAGEMENT_PACK_ACCESS='DIAGNOSTIC+TUNING';
GRANT advisor, administer SQL tuning SET,SELECT any dictionary TO &USER;
GRANT advisor to &USER;
GRANT administer sql tuning set to &USER;
EXEC DBMS_STATS.DELETE_SCHEMA_STATS ('&USER');

And show this toturial to help you
link

source:

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r32/Tuning_Advisor_OBE/SQL%20Tuning%20Advisor.html

http://www.dbzoo.com/blog/enabling_oracle_sql_advisor

You may also like...