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

VIEW: SYS.SCHEDULER$_CDB_WINDOW

Object Details
Object Name: SCHEDULER$_CDB_WINDOW
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
RES_PLAN VARCHAR2 (128)
NEXT_START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
MANUAL_OPEN_TIME TIMESTAMP(6) WITH TIME ZONE (13)
DURATION INTERVAL DAY(3) TO SECOND(0) (11)
MANUAL_DURATION INTERVAL DAY(3) TO SECOND(0) (11)
SCHEDULE_EXPR VARCHAR2 (4000)
START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
END_DATE TIMESTAMP(6) WITH TIME ZONE (13)
LAST_START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
ACTUAL_START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
SCALING_FACTOR NUMBER

CREATOR VARCHAR2 (128)
UNUSED_SLAVE_POLICY NUMBER

MIN_SLAVE_PERCENT NUMBER

MAX_SLAVE_PERCENT NUMBER

SCHEDULE_ID NUMBER

FLAGS NUMBER

MAX_CONC_JOBS NUMBER

PRIORITY NUMBER

COMMENTS VARCHAR2 (240)
CON_ID NUMBER

container id
Query Text

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


SELECT OBJ#
,      RES_PLAN
,      NEXT_START_DATE
,      MANUAL_OPEN_TIME
,      DURATION
,      MANUAL_DURATION
,      SCHEDULE_EXPR
,      START_DATE
,      END_DATE
,      LAST_START_DATE
,      ACTUAL_START_DATE
,      SCALING_FACTOR
,      CREATOR
,      UNUSED_SLAVE_POLICY
,      MIN_SLAVE_PERCENT
,      MAX_SLAVE_PERCENT
,      SCHEDULE_ID
,      FLAGS
,      MAX_CONC_JOBS
,      PRIORITY
,      COMMENTS
,      CON_ID
FROM SYS.SCHEDULER$_CDB_WINDOW;

Dependencies

[top of page]

SYS.SCHEDULER$_CDB_WINDOW does not reference any database object

SYS.SCHEDULER$_CDB_WINDOW is not referenced by any database object