Obtaining Advice for a Group of SQL Statements
To make full use of the SQL Access Advisor features, we strongly recommend you use the Enterprise Manager SQL Access Advisor Wizard. This browser-based interface allows you to visually select from a vast number of features and options. Using this graphical tool is much more efficient than trying to manually generate the code required when using the
DBMS_ADVISOR PL/SQL package. Keep in mind that you can always view and modify the PL/SQL that Enterprise Manager generates if you need to fine-tune the code to meet your requirements.
In the next several paragraphs we demonstrate an example that generates indexing advice for the SQL currently running in memory. First, log in to Enterprise Manager and navigate ...