Description:

Active Session History (ASH) was introduced in Oracle Database 10g as part of the instrumentation to support the Automatic Database Diagnostic Monitor (ADDM) and has been enhanced in each subsequent release. The sampled data in ASH allows us to do highly detailed performance analysis in many different dimensions (session, SQL, application etc.). Examples will be presented of using ASH to identify the source of performance problems with emphasis on using the newer capabilities.