DBA_AUTOTASK_WINDOW_CLIENTS

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
WINDOW_NAME VARCHAR2(30) NOT NULL Name of the maintenance window
WINDOW_NEXT_TIME TIMESTAMP(6) WITH TIME ZONE   Next scheduled window open time unless the window is disabled
WINDOW_ACTIVE VARCHAR2(5)   Indicates whether the window is currently active (open) (TRUE) or not (FALSE)
AUTOTASK_STATUS VARCHAR2(8)   Status of the automated maintenance task subsystem:

  • ENABLED

  • DISABLED
OPTIMIZER_STATS VARCHAR2(8)   Status of optimizer statistics gathering:

  • ENABLED

  • DISABLED
SEGMENT_ADVISOR VARCHAR2(8)   Status of Segment Advisor:

  • ENABLED

  • DISABLED
SQL_TUNE_ADVISOR VARCHAR2(8)   Status of SQL Tuning Advisor:

  • ENABLED

  • DISABLED
HEALTH_MONITOR VARCHAR2(8)   Status of Health Monitor:

  • ENABLED

  • DISABLED