Reviewing the Automatic Database Diagnostic Monitor Analysis

By default, ADDM runs every hour to analyze snapshots taken by AWR during that period. If the database finds performance problems, then it displays the results of the analysis under Diagnostic Summary on the Database Home page.

The ADDM Findings link shows how many ADDM findings were found in the most recent ADDM analysis.

To view ADDM findings: 

1. On the Database Home page, under Diagnostic Summary, click the link next to ADDM Findings.

   The Automatic Database Diagnostic Monitor (ADDM) page appears. The results of the ADDM run are displayed.

   On the Automatic Database Diagnostic Monitor (ADDM) page, the Database Activity chart shows the database activity during the ADDM analysis period. Database activity types are defined in the legend based on their corresponding colors in the chart. Each icon below the chart represents a different ADDM task, which in turn corresponds to a pair of snapshots saved in AWR.

   In the ADDM Performance Analysis section, ADDM findings are listed in descending order, from highest to least impact. The Informational Findings section lists areas that have no performance impact and are for information only.

2. Optionally, click the Zoom icons to shorten or lengthen the analysis period displayed on the chart.

3. To view the ADDM findings in a report, click View Report.

   The View Report page appears.

   You can click Save to File to save the report for later access.