Generating Active Session History Reports

http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/autostat.htm#CHDIDEDG

Use Active Session History (ASH) reports to perform analysis of:

·         Transient performance problems that typically last for a few minutes

·         Scoped or targeted performance analysis by various dimensions or their combinations, such as time, session, module, action, or SQL_ID

You can view ASH reports using Enterprise Manager or by running the following SQL scripts:

·         The ashrpt.sql SQL script generates an HTML or text report that displays ASH information for a specified duration.

·         The ashrpti.sql SQL script generates an HTML or text report that displays ASH information for a specified duration for a specified database and instance.