In a few of my previous blogs, I provided instructions on how to use 10G Grid Control to run the SQL Tuning Advisor and the SQL Access Advisor. In this next couple of blogs, we’ll peel back the layers and find out exactly what happens when these utilities are executed.

In part one of this multi-part blog on the advisors, we take a look at how the SQL Tuning Advisor uses the optimizer to generate its tuning recommendations. We’ll also cover the types of recommendations it provides and how it comes to those conclusions.