Using the Advisors for Tuning

Let's now look at how to use the SQL advisors for tuning by taking a tour using OEM. As indicated before, the advisors are available from a variety of sources including the Advisor Central link in most OEM screens.

OEM Interface to the SQL Tuning Advisor

Launch the SQL Tuning Advisor from its link on the Advisor Central page. This displays a screen that lists all the possible inputs to this advisor. The links are as follows:

  • Top SQL. Useful for obtaining tuning advice for either Spot SQL or Period SQL. The former shows all the Top SQL executed in a five-minute period in the immediate past, while the latter shows all the Top SQL for the past 24 hours or so. These SQLs are sorted by some criteria—in this case, activity ...

Get Oracle® Database 10g Insider Solutions now with O’Reilly online learning.

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