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 ...

Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.