My Oracle Support Banner

Analysis of Active Session History (Ash) Online and Offline (Doc ID 243132.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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.