President & Founder, OraPub Inc. Oracle Ace Director
OraPub, Inc. USA
Craig is a long time Oracle DBA who specializes in Oracle tuning and machine learning and started the OraPub website in 1995. Craig is a performance researcher and blogger, consultant, author of two books, an enthusiastic conference speaker and a passionate teacher to thousands of Oracle professionals. He clearly pushes the teaching envelope with his performance-focused membership program, webinars and videos! Craig has received a number of technical, effectiveness and community involvement awards. Craig is also an Oracle ACE Director.
How To Analyze SQL Run Times By Plan Using ASH Data (Connect 2019)
Event: Connect 2019
Stream:DBAs; Developers; Managers
Imagine knowing SQL run times without instrumenting your application. That is exactly what I will teach you how to do by analyzing ASH data. Suppose the ticket shows, "This query takes 45 seconds!" How can you confirm that? Is 45 seconds unusual? Has it happened before? Perhaps there is a bad plan being used? What is a good plan for the SQL? This is valuable information that creatively analyzing ASH data will reveal. In this presentation, using ASH data, I will show you how to manually infer SQL run times. Then I'll show you how to use a simple yet flexible SQL script to analyze ASH data, infer SQL run times and report the results... even at the execution plan level. Next I'll show you how to analyze the run time samples using the free statistical package R. Join me as we explore the untapped analysis opportunities ASH data provides.