Using the Dynamic Oracle Performance Analytics Framework

I will be presenting:

Using the Dynamic Oracle Performance Analytics Framework”

Session ID: 239 Wed, 10-Apr-19 (9:15 AM – 10:15 AM)

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

Abstract Summary:

Use the innovative Dynamic Oracle Performance Analytics (DOPA) approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach discussed in this presentation is accessible and easy to use, but more importantly it represents a step-change paradigm shift away from traditional methods. Instead of relying on a few hand-picked, favorite metrics, or wading through multiple specialized tables of information such as those found in an automatic workload repository (AWR) report, you can draw on all available data, applying big data methods and analytical techniques to help you draw impactful, focused performance improvement conclusions.   The DOPA process targets the most relevant metrics for the problem interval which results in event focused and actionable intelligence on the performance issue, and insight into possible solutions.  This method improves on the typical/traditional approaches which monitor a standard set of hard coded metrics; but the traditional approaches may cause you to miss important system behavior or configuration that is relevant to the root cause of the performance problem.  The speaker will share his DOPA process and code.

Using the Dynamic Oracle Performance Analytics Framework - C19TX.png

Scale-Up Your Use of the Advisor Framework

My Book: Dynamic Oracle Performance Analytics Using Normalized Metrics