Description of the illustration perf_analysis.gif

This screenshot contains a table. The table contains the following columns: Impact (%), Finding, Occurrences (last 24 hours). The values in the Finding and Occurrences columns are links. Values in the Impact column are shown as a horizontal bar and labeled with a number.

In the ADDM Performance Analysis section, 4 ADDM Findings are listed.

The first ADDM Finding shows that SQL statements are consuming significant database time. The impact of this finding is 83.7%.

The second ADDM Finding shows that the "Scheduler" Wait Class was consuming significant database time. The impact of this finding is 23.4%.

The third ADDM Finding shows that Log File Switches were consuming significant database time. The impact of this finding is 3.5%.

The fourth ADDM Finding shows that an Undersize Buffer Cache was consuming significant database time. The impact of this finding was 2.1%.

End of description.