Oracle Performance Tuning — Roger Cornejo

Aug 27
Aug 27 Introduction to SQL Insights: Understanding the Cursor Sharing Issue

Aug 23
Aug 23 Introduction to SQL Insights: Understanding Execution Plan Changes

Aug 21
Aug 21 Introduction to SQL Insights: Cursor Invalidation Storms

Aug 6
Aug 6 Oracle’s OPS Insights: Database Performance Analytics for Everyone

Jul 8
Jul 8 Presenting on “SQL and Analytics - Unleashing the Full Potential” to Quest Oracle Database 19c Meet-Up

Mar 29
Mar 29 Taming the AWR Tsunami 06 - Correlations Among Performance Metrics

Mar 27
Mar 27 Taming the AWR Tsunami 05 – Extracting Value from dba_hist_sql_plan

Mar 25
Mar 25 Taming the AWR Tsunami 04 – Logon Storms and Session Leaking

Mar 22
Mar 22 Taming the AWR Tsunami 03 – dba_hist_sqlstat

Mar 20
Mar 20 Taming the AWR Tsunami 02 – Active Session History

Mar 19
Mar 19 Taming the AWR Tsunami - A Deep Dive into AWR Data (an Introduction)

Jul 3
Jul 3 Optimizing Oracle Applications - Harnessing SQL Profiles and SQL Plan Baselines

Jun 23
Jun 23 Discovering Performance Anomalies - Index Compression Overhead in High Volume Insert Workloads

May 31
May 31 Maximizing Application Performance: Unleashing the Power of Oracle’s Diagnostic and Tuning Pack Privileges for Non-DBAs

May 26
May 26 Discovering Hidden Secrets of CPU Utilization in Oracle Databases, pt2

May 18
May 18 Discover the Hidden Secrets of CPU Utilization in Oracle Databases

May 16
May 16 Unlocking Hidden Insights: Leveraging Taxonomies for Anomaly Detection Among Oracle Performance Metrics

May 12
May 12 The Oracle ACE Program

Feb 14
Feb 14 SQL and Analytics: A Dynamic Duo

Feb 14
Feb 14 RMOUG Database Performance Analytics Using Anomaly Detection