Running the SQL Access Advisor: Schedule
Use the SQL Access Advisor Schedule page, shown in Figure 11–1, to set or modify the schedule parameters for the SQL Access Advisor task.
Figure 11–1 Scheduling a SQL Access Advisor Task
To schedule a SQL Access Advisor task:
1. On the SQL Access Advisor: Schedule page, under Advisor Task Information, enter a name in the Task Name field if you do not want to use the
system-generated task name.
In the example shown in Figure 11–1, ICHAN20061023 is entered.
2. In the Task Description field, enter a description of the task.
In the example shown in Figure 11–1, SQL Access Advisor is entered.
3. From the Journaling Level list, select the level of journaling for the task.
Tip: Before you can schedule a SQL Access Advisor task, you need to:
Q Select initial options, as described in "Running the SQL Access Advisor: Initial Options" on page 11-2
Q Select the workload source, as described in "Running the SQL Access Advisor: Workload Source" on page 11-3
Q Define the filter options, as described in "Running the SQL Access Advisor: Filter Options" on page 11-5
Q Specify the recommendation options, as described in "Running the SQL Access Advisor: Recommendation Options" on page 11-7
Running the SQL Access Advisor
Optimizing Data Access Paths 11-11 Journaling level controls the amount of information that is logged to the SQL Access Advisor journal during task execution. This information appears on the Details subpage when viewing task results. Available journaling levels include:
Q None
No information is logged.
Q Basic
Information such as errors, warnings, and roll-ups of activities are logged.
Q Moderate
Information such as major progress steps, SQL statements skipped, SQL statements processed, and analysis details are logged.
Q Full
All available information is logged.
In the example shown in Figure 11–1 on page 11-10, Basic is selected.
4. In the Task Expiration (Days) field, enter the number of days the task will be retained in the database before it is purged.
In the example shown in Figure 11–1 on page 11-10, 30 is entered.
5. Under Scheduling Options, in the Schedule Type list, select a schedule type for the task and a maintenance window in which you want the task to run.
The available schedule types include:
Q Standard
This schedule type enables you to select a repeating interval and start time for the task.
Under Repeating, select the repeating interval using the Repeat and Interval fields, or Do Not Repeat if you do not want the task to repeat automatically.
Under Start, select Immediately to start the task immediately, or Later to schedule the task to start at a time specified using the Date and Time fields.
Q User pre-defined schedule
This schedule type enables you to select an existing schedule to use.
In the Schedule field, enter the name of the schedule you want to use for the task. To search for a schedule, click the Schedule search icon. The Search and Select: Schedule dialog box appears. Select the schedule you want to use and click Select. The selected schedule now appears in the Schedule field. To display details about the schedule, click View Details.
Q Standard using PL/SQL for repeated interval
This schedule types enables you to select a repeating interval and an execution window for the task.
Under Available to Start, select Immediately to make the task available to start immediately, or Later to schedule the task to become available at a time specified using the Date and Time fields.
Under Repeated Interval, enter a PL/SQL schedule expression, such as SYSDATE+1.
Running the SQL Access Advisor
Under Not Available After, select No End Date if you do not want to use an end date for the execution window, or Specified End Date to specify an end date using the Date and Time fields.
Q User pre-defined window
In the Window field, select a window to run the task during specific time periods. You can run the task in multiple windows by grouping the windows in a window group.
To search for a window, click the Window search icon. The Search and Select:
Window and Window Groups dialog box appears. Select the window or window group you want to use and click Select. The selected window or window group now appears in the Window field.
To stop the task if the available window or window group closes, check the Stop on Window Close box.
In the example shown in Figure 11–1 on page 11-10, Standard is selected for schedule type. The task will not repeat and is scheduled to start immediately.
6. Click Next.
The Review page appears. Under Options, a list of all options for the SQL Access Advisor task is displayed. Options that are modified can be identified by the check marks in the Modified column. The value for each option is displayed in the Value column. To view the SQL text for the task, click Show SQL.
7. After reviewing the options on the Review page, click Submit to submit the SQL Access Advisor task.
The Advisor Central page appears and a message is displayed to inform you that the task was created successfully.