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

• Top DB Files

• Activity Over Time