DBA_AUTOTASK_WINDOW_CLIENTS displays 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.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the maintenance window |
|
|
|
Next scheduled window open time unless the window is disabled |
|
|
|
|
Indicates whether the window is currently active (open) ( |
|
|
|
|
Status of the automated maintenance task subsystem:
|
|
|
|
|
Status of optimizer statistics gathering:
|
|
|
|
|
Status of Segment Advisor:
|
|
|
|
|
Status of SQL Tuning Advisor:
|
|
|
|
|
Status of Health Monitor:
|