Configuring the Automatic SQL Tuning Advisor

The following are some configuration tasks that you might want to perform for the Automatic SQL Tuning Advisor:

• Enable automatic implementation of SQL profile recommendations.

  Automatic implementation is disabled by default.

• Select the maintenance windows (time periods) in which the advisor runs.

  The Automatic SQL Tuning Advisor runs in all maintenance windows by default.

• Modify the start time and duration of existing maintenance windows or create new maintenance windows.

To configure the Automatic SQL Tuning Advisor:

1. Go to the Database Home page, logging in as user SYS.

   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.

   
   Description of the illustration auto_maint_tasks_new.gif
   
   

4. Click Configure.

   The Automated Maintenance Tasks Configuration page appears.

5. (Optional) To disable the Automatic SQL Tuning Advisor, in the Task Settings section, click the Disabled option for Automatic SQL Tuning.

6. (Optional) To prevent the Automatic SQL Tuning Advisor from running in particular maintenance windows, in the Maintenance Window Group Assignment section, deselect check boxes under the Automatic SQL Tuning heading.

7. Click Apply to save any changes made so far.

   A confirmation message is displayed.

8. To enable automatic implementation of SQL profile recommendations, complete the following steps:

   1. In the Task Settings section, next to the Automatic SQL Tuning options, click Configure.

      The Automatic SQL Tuning Settings page appears.

   2. Next to Automatic Implementation of SQL Profiles, click the Yes option.

      You must be logged in as user SYS to change this option.

   3. Click Apply.

      A confirmation message is displayed.

   4. In the locator links at the top, left-hand side of the page, click Automated Maintenance Tasks Configuration to return to the Automated Maintenance Tasks Configuration page.

9. (Optional) To make changes to the start time and duration of existing maintenance windows, to disable individual maintenance windows, or to create additional maintenance windows, click Edit Window Group.

   The Edit Window Group page appears. From this page you can change the settings of individual windows or you can add or remove windows to or from the window group MAINTENANCE_WINDOW_GROUP.

   See the online Help for this page for more information.

   Note: If you create a new window (time period) to run automated maintenance tasks, then you must add that window to MAINTENANCE_WINDOW_GROUP.