Performance Tuning Using the Advisor Framework

Tired of grinding away to try to come up with a database tuning action plan? This presentation details how to get to database tuning actions more quickly by aggregating findings and recommendations across multiple Advisor runs. The author details his custom tools (simple SQL statements) that expose many undocumented features of the Advisor framework. In the DBA or developer’s hands, these tools can massively scale-up your ability to action tuning opportunities exposed by the various Advisors. The excellent findings and recommendations that come out of the various Advisors such as the SQL Tuning Advisor, the Automated Database Diagnostics Monitor (ADDM), the Segment Tuning Advisor, and the SQL Access Advisor will be of particular focus in this presentation.