Description of the illustration edit_job_seg_advisor.gif

This screenshot shows the Automated Maintenance Tasks Configuration page. At the top are the following options next to a Global Status heading: Enabled and Disabled. Beneath these options are two sections, aligned at the left-hand side of the page:

• Task Settings—This section contains a group of three settings, where each setting has an Enabled and Disabled option. The settings are labeled with the three automated maintenance tasks: Optimizer Statistics Gathering, Segment Advisor, and Automatic SQL Tuning. Next to the first and last setting is a Configure button.

• Maintenance Window Group Assignment—This section contains a matrix of check boxes, with column and row headings. The seven row headings at the left are names of maintenance windows: MONDAY_WINDOW, TUESDAY_WINDOW, and so on. The three column headings are the names of the automated maintenance tasks. Just below each column heading is a pair of links: Select All and Select None.