Automated Maintenance Tasks Reference

This section contains the following reference topics for automated maintenance tasks:

Predefined Maintenance Windows
Automated Maintenance Tasks Database Dictionary Views

Predefined Maintenance Windows

By default there are seven predefined maintenance windows, each one representing a day of the week. The weekend maintenance windows, SATURDAY_WINDOW and SUNDAY_WINDOW, are longer in duration than the weekday maintenance windows. The window group MAINTENANCE_WINDOW_GROUP consists of these seven windows. The list of predefined maintenance windows is given in Table 24-1.

Table 24-1 Predefined Maintenance Windows

Window Name	Description
`MONDAY_WINDOW`	Starts at 10 p.m. on Monday and ends at 2 a.m.
`TUESDAY_WINDOW`	Starts at 10 p.m. on Tuesday and ends at 2 a.m.
`WEDNESDAY_WINDOW`	Starts at 10 p.m. on Wednesday and ends at 2 a.m.
`THURSDAY_WINDOW`	Starts at 10 p.m. on Thursday and ends at 2 a.m.
`FRIDAY_WINDOW`	Starts at 10 p.m. on Friday and ends at 2 a.m.
`SATURDAY_WINDOW`	Starts at 6 a.m. on Saturday and is 20 hours long.
`SUNDAY_WINDOW`	Starts at 6 a.m. on Sunday and is 20 hours long.

Automated Maintenance Tasks Database Dictionary Views

Table 24-2 displays information about database dictionary views for automated maintenance tasks:

Table 24-2 Automated Maintenance Tasks Database Dictionary Views

View Name	Description
`DBA_AUTOTASK_CLIENT_JOB`	Contains information about currently running Scheduler jobs created for automated maintenance tasks. It provides information about some objects targeted by those jobs, as well as some additional statistics from previous instantiations of the same task. Some of this additional data is taken from generic Scheduler views.
`DBA_AUTOTASK_CLIENT`	Provides statistical data for each automated maintenance task over 7-day and 30-day periods.
`DBA_AUTOTASK_JOB_HISTORY`	Lists the history of automated maintenance task job runs. Jobs are added to this view after they finish executing.
`DBA_AUTOTASK_WINDOW_CLIENTS`	Lists the windows that belong to `MAINTENANCE_WINDOW_GROUP`, along with the Enabled or Disabled status for the window for each maintenance task. Primarily used by Enterprise Manager.
`DBA_AUTOTASK_CLIENT_HISTORY`	Provides per-window history of job execution counts for each automated maintenance task. This information is viewable in the Job History page of Enterprise Manager.