My Oracle Support Banner

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.

Purpose

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.

Scope

 The intended audience is for database DBA's

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.