Description of the illustration perf_hub_paddm_perf.gif

This is a screen shot of the Automatic Database Diagnostic Monitor (ADDM) page. The top right of the page shows the time the page was last refreshed.

The ADDM Performance Analysis section at the top of the page includes these fields and values:

• Task Name: ADDM:670573462_1_24

• Task Owner: SYS

• Average Active Sessions: 4.4

• Period Start Time: Thu, Sep 27, 2012 9:00:18 AM

• Period End Time: Thu, Sep 27, 2012 10:00:03 AM

Below the fields and values is a Findings table that includes three findings with these columns and values:

• Finding: Top SQL Statements

• Impact (%): 89.0%

• Number of Recommendations: 5

• Finding: PL/SQL Execution

• Impact (%): 32.5%

• Number of Recommendations: 1

• Finding: Row Lock Waits

• Impact (%): 22.2%

• Number of Recommendations: 1

Below the table is the Informational Findings section, which includes these sentences:

• Wait class "Commit" was not consuming significant database time.

• Wait class "Configuration" was not consuming significant database time.

• Wait class "Network" was not consuming significant database time.

• Session connect and disconnect calls were not consuming significant database time.

• Hard parsing of SQL statements was not consuming significant database time.