Analysis of Active Session History (Ash) Online and Offline
(Doc ID 243132.1)
Last updated on SEPTEMBER 25, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Diagnostics Pack
Information in this document applies to any platform.
The note describes how to dump ASH information to trace to do online or offline analysis.
The ASH infrastructure provides a single V$ view (V$ACTIVE_SESSION_HISTORY), to view the in-memory contents of ASH along with a way to dump the in-memory contents of its circular buffer into an external file in a human readable format. The ASH dump file can be transported to another system, imported onto a user table, and analyzed using the ADDM in that system.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!