Active Session History Reports

You can use an ASH report to identify the source of transient performance problems. The report is divided into titled sections. The following sections of the ASH report are useful places to begin the investigation:

• Top Events

• Load Profile

• Top SQL

• Top Sessions

• Top DB Objects/Files/Latches

• Activity Over Time

See Also:

• Oracle Database Performance Tuning Guide for more detailed information about ASH reports