Loading…
← Back to schedule
How To Estimate SQL Run Times Without Application Code Modifications
Tuesday March 25, 2025 2:30pm - 3:15pm MDT
Room 220
Imagine knowing SQL run times without modifying your application code. That's exactly what I'll demonstrate by diving into ASH data.

Picture this: A ticket reports, "This query takes 45 seconds!" How can you verify that? Is 45 seconds typical? Has it happened before? Could it be using a suboptimal execution plan? By analyzing ASH data, we'll answer these questions and more.

In this session, I'll show you how to manually infer SQL run times from ASH data. I'll then introduce a flexible SQL script that analyzes ASH data, infers run times, and reports results—down to the execution plan level. Finally, we'll use a simple spreadsheet to review and analyze the results. Join me as we explore a hidden gem in ASH data analysis!
Speakers
avatar for Craig Shallahamer

Craig Shallahamer

Applied AI Scientist, OraPub / Viscosity North America
Having worked with Oracle technology since 1989, Craig Shallahamer is a leader in the fields of machine learning, artificial intelligence and Oracle database performance tuning.Craig has extensive experience in constructing and teaching predictive modeling methods, notably developing... Read More →
Tuesday March 25, 2025 2:30pm - 3:15pm MDT
Room 220
  Infrastructure (including database), Development

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Share Modal

Share this link via

Or copy link