Home / Educational Content / Database & Technology / Performance Tuning Using the Advisor Framework

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.

Watch the full-length video

Premium Content: access is limited to Quest Corporate and Professional members.

Membership has its perks. Get unlimited access to the latest Oracle updates, event session replays, strategic content centers and special members-only programming, plus big discounts on conference registration, with a Quest Corporate or Professional membership. Quest is where you learn.

Performance Tuning Using the Advisor Framework