Using the Dynamic Oracle Performance Analytics Framework

Session Number: 8451
Track: Database
Sub-Categorization: DBA
Session Type: Tips, Techniques and Tuning
Primary Presenter: Roger Cornejo [Principal Oracle Performance Consultant - GlaxoSmithKline]
Time: Jun 26, 2019 (09:00 AM - 10:00 AM)
Room: 618, Level 6

Speaker Bio: Oracle ACE Roger Cornejo has over 34 years of experience with large/complex Oracle applications (versions 4.1.4 – 18c). Roger’s main focus is on DB performance analysis and tuning, and for the past eight years, diving deep into AWR tuning data. He is often relied on to produce Oracle Database tuning results across 18c/12c/11g/10g (and occasionally 9i) databases. As a thought leader, he has been sought out for his expertise in tuning (presenter at the past eight East Coast Oracle Conferences, as well as COLLABORATE14 and COLLABORATE18 & 19, RMOUG16, and Hotsos 2017-2018). Additionally, Roger authored a book on his recent work, Dynamic Oracle Performance Analytics: Using Normalized Metrics to Improve Database Speed, which is soon to be released by Apress (available for pre-order).
Technologies or Products Used: Oracle Database; AWR

Session Summary for Attendees:  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.