I will be presenting at the MOUG / COUG Tech Day - July 18th 2019:
Using the Dynamic Oracle Performance Analytics Framework
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. I will share my DOPA process and code.