Scale-Up Your Use of the Advisor Framework

I will be presenting:

“Scale-Up Your Use of the Advisor Framework”

Session ID: 240 Mon, 08-Apr-19 (03:15 PM - 04:15 PM)

#C19TX Collaborate 2019 – @IOUG Forum , April 7-11, 2019 San Antonio, TX

#Oracle #Tuning #performance #performancetuning

Abstract Summary:

Transform your ability to quickly respond to the challenge of ensuring high performing DB’s. The key to this transformation is to expertly use the advisor framework which underlies tools such as ADDM, SQL Tuning Advisor, Segment Tuning.  These tools provide actionable advice to the DBA seeking to solve performance problems but getting at this information can be painstaking.  This presentation shows you many undocumented ways to proficiently use the underlying data to quickly get to tuning solutions.


ADDM* regularly runs behind the scenes and persists various performance tuning solutions that often go unnoticed by the DBA.  Since DB performance problems can escalate quickly, the use of these persisted solutions can transform the DBA’s ability to skillfully devise a tuning action plan.  To leverage these preexisting solutions, the presenter “reverse engineered” the advisor framework and developed some SQL queries that will help the DBA evaluate the solutions and extract the details and/or SQL needed to implement the solutions.  This presentation takes a deep dive into the various ADDM tools and details these custom queries against ADDM base data.  Every DBA will leave this presentation with more confidence, new tools and approaches for solving Oracle database application performance problems.


*ADDM (Automated Performance Diagnostics and Monitoring) is a key component in Oracle’s implementation of a self-managing database [part of the Diagnostics and Tuning pack license].  Within the persisted ADDM data, one will find solutions from automatic runs of the SQL Tuning Advisor, Segment Tuning Advisor, hourly ADDM runs, and more.

Scale-Up Your Use of the Advisor Framework  - C19TX.png

Source Code for “Dynamic Oracle Performance Analytics”

Using the Dynamic Oracle Performance Analytics Framework