Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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