Taking ASH Analysis To The Next Level - Plan Change and Parsing

• strange • unusual • powerful •

Download Now

Sometimes snapshot time-based (AWR) performance data does not provide the level of detail we need to diagnose performance issues. Plus there can be time data 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. In this presentation I will show you how to use ASH data to pinpoint SQL plan changes. Also, I 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!

The download zip file contains both the presentation in PDF and the core SQL statements. Some of the scripts used are from the OraPub ASH Scratch Pad toolkit.

Search Craig's blog for relevant posts, here.

Related Videos