Implementing Automatic Database Diagnostic Monitor Recommendations

This section describes how to implement ADDM recommendations. ADDM findings are displayed in the Automatic Database Diagnostic Monitor (ADDM) page under ADDM Performance Analysis.

To implement ADDM recommendations: 

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

   The Automatic Database Diagnostic Monitor (ADDM) page appears.

2. In the Database Activity section, click the icon for the ADDM run that you want to investigate.

3. In the ADDM Performance Analysis section, click the ADDM finding that has the greatest impact.

   In this example, the finding with the greatest impact is Top SQL Statements.

   The Performance Finding Details page appears.

4. Under Recommendations, click Show to review the recommendations and required actions for each recommendation.

   The Category column displays the category of the recommendation. The Benefit (%) column displays the estimated benefit of implementing the recommendation.

5. If additional information about why the set of actions was recommended is available, then click Additional Information, or review the content displayed under Additional Information.

6. To view the history of a finding, click Finding History.

   The Finding History page appears.

   The Finding History page shows how often a particular finding has occurred in a selected 3-hour interval. You can use this information to determine whether the finding was a transient or a persistent problem on the system. Based on this information, you can determine whether the actions associated with the finding should be implemented.

   The Active Sessions chart shows the impact of the finding and of the other load on the system. You can change the display as follows:

   1. To move the 3-hour interval, click and drag the shaded box in the Active Sessions chart to the time period in which you are interested.

   2. To change dates, enter the desired date in the View field, and then click Go.

   3. To view details about a finding, under Detail for Selected 3 Hour Interval, click the link in the Finding Details column to display the Performance Finding Details page for the corresponding ADDM finding.

7. Optionally, create a filter to suppress known findings that have been tuned or cannot be tuned further. To create filters for a selected ADDM finding:

   1. Click Filters.

      The Filters for Finding page appears.

   2. Click Create.

      The Create Filter for Finding page appears.

   3. In the Name field, enter a name for the ADDM filter.

   4. In the Active Sessions field, specify the filter criteria in terms of the number of active sessions.

      The ADDM finding will be filtered for future ADDM runs if the number of active sessions for the finding is less than the specified filter criteria.

   5. In the % Active Sessions field, specify the filter criteria in terms of percentage of active sessions.

      The ADDM finding will be filtered for future ADDM runs if the number of active sessions for the finding is less than the specified filter criteria.

   6. Click OK.

8. Perform the required action of a chosen recommendation.

   Depending on the type of action you choose to perform, various options may be available, such as Implement or Run Advisor Now. These options enable you to implement the recommendation immediately with a single mouse click.

   Related Topics

   Tuning SQL Statements

   Automatic Database Performance Monitoring