DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_SCHEDULER_WINDOW_GROUPS

Object Details
Object Name: DBA_SCHEDULER_WINDOW_GROUPS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All scheduler window groups in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
WINDOW_GROUP_NAME VARCHAR2 (128) Yes Name of the window group
ENABLED VARCHAR2 (5)
Whether the window group is enabled
NUMBER_OF_WINDOWS NUMBER

Number of members in this window group
NEXT_START_DATE VARCHAR2 (64)
Next start date of this window group
COMMENTS VARCHAR2 (240)
An optional comment about this window group
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT WINDOW_GROUP_NAME
,      ENABLED
,      NUMBER_OF_WINDOWS
,      NEXT_START_DATE
,      COMMENTS
FROM SYS.DBA_SCHEDULER_WINDOW_GROUPS;

Dependencies

[top of page]

SYS.DBA_SCHEDULER_WINDOW_GROUPS references the following:

SchemaSYS
TableOBJ$
TableSCHEDULER$_WINDOW
TableSCHEDULER$_WINDOW_GROUP
TableSCHEDULER$_WINGRP_MEMBER
SYS.DBA_SCHEDULER_WINDOW_GROUPS is referenced by following:

SchemaPUBLIC
SynonymDBA_SCHEDULER_WINDOW_GROUPS
SchemaSYS
ViewALL_SCHEDULER_WINDOW_GROUPS
Package BodyDBMS_AUTO_TASK_EXPORT - show dependent code