Back To Schedule
Wednesday, March 21 • 3:30pm - 4:30pm
Taking ASH Analysis to the Next Level—Plan Change and Parsing Detection/Analysis

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

Feedback form is now closed.
Sometimes snapshot time-based (AWR) performance data does not provide the level of detail we need to diagnose performance issues. Usually Oracle Active Session History (ASH) data solves this limitation by providing session-level sample data. However, we can go further by creatively using ASH data to do things that are not possible using standard ASH and time-based analysis. This presentation will demonstrate how to use ASH data to pinpoint SQL plan changes. Also, it will show you how to detect parsing issues before they show up in the wait interface. The presentation includes demonstrations and where to get the free SQL, so you can take your ASH analysis to the next level!

avatar for Craig Shallahamer

Craig Shallahamer

President/Founder/DBA, OraPub, Inc.
Craig is a long time Oracle DBA who specializes in Oracle tuning 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... Read More →

Wednesday March 21, 2018 3:30pm - 4:30pm MDT
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112