Viewing Automatic SQL Tuning Results

You can track the activities of the Automatic SQL Tuning Advisor with Database Control.

To view automatic SQL tuning results:

1. Go to the Database Home page.

   See "Accessing the Database Home Page".

2. Click Server to display the Server page.

3. In the Oracle Scheduler section, click Automated Maintenance Tasks.

   The Automated Maintenance Tasks page appears.

4. Click Automatic SQL Tuning.

   The Automatic SQL Tuning Result Summary page appears, showing graphical summaries of the Automatic SQL Tuning Advisor activities and findings.

   
   Description of the illustration auto_sqltuning_r2_new.gif
   
   

5. To view recommendations, click View Report under the heading Task Activity Summary.

   The Automatic SQL Tuning Result Details page appears, showing the SQL statements for which recommendations were made during the designated period.

   A green check mark in the SQL Profile column indicates a recommendation that was automatically implemented.

   By default, automatic implementation is disabled. See "Configuring the Automatic SQL Tuning Advisor" for instructions for enabling it.

6. (Optional) Select a SQL statement in the Recommendations table (based on the SQL Text column), and then click View Recommendations.

   The Recommendations for SQL ID page appears, describing each recommendation for the statement in detail. On this page, you can select a recommendation and then click Implement to implement it.