ASH Report Structure

The ASH Report follows the pattern of the AWR report. Starting from the upper right of the slide, the report sections are as follows:

• Top Events: Reports the user events, background events, and the event parameter values

• Load Profile: Reports the top service/module, top clients, identifies the type of SQL commands and top phases of execution

• Top SQL: Reports top SQL statements associated with the top events, SQL associated with the top rowsources, top SQL using literals, and the SQL text for these SQL statements.

• Top PL/SQL Procedures: Lists the PL/SQL procedures that accounted for the highest percentages of sampled session activity

• Top Java Workload: Describes the top Java programs in the sampled session activity 

• Top Sessions: Reports the top sessions found waiting, top blocking sessions, and aggregates for PQ sessions

• Top Objects/Files/Latches: Reports the top objects, files, or latches that were involved in a wait 

• Activity Over Time: Reports the top three wait events for 10 equally sized time periods during the report period