UTOUG Training Days 2018

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!