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

VIEW: SYS.DBA_SCHEDULER_WINDOW_DETAILS

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

The details of a window

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOG_ID NUMBER

The unique id of the log entry. Foreign key on entry in dba_scheduler_window_log
LOG_DATE TIMESTAMP(6) WITH TIME ZONE (13)
The date of the log entry
OWNER VARCHAR2 (128)
The owner of the scheduler window
WINDOW_NAME VARCHAR2 (261)
The name of the scheduler window
REQ_START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
The requested start date for the scheduler window
ACTUAL_START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
The date the scheduler window actually started
WINDOW_DURATION INTERVAL DAY(3) TO SECOND(0) (11)
The original duration of the scheduler window
ACTUAL_DURATION INTERVAL DAY(3) TO SECOND(0) (11)
The actual duration for which the scheduler window lasted
INSTANCE_ID NUMBER

The id of the instance on which this window ran
ADDITIONAL_INFO VARCHAR2 (4000)
Additional information on this entry, if applicable
Query Text

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


SELECT LOG_ID
,      LOG_DATE
,      OWNER
,      WINDOW_NAME
,      REQ_START_DATE
,      ACTUAL_START_DATE
,      WINDOW_DURATION
,      ACTUAL_DURATION
,      INSTANCE_ID
,      ADDITIONAL_INFO
FROM SYS.DBA_SCHEDULER_WINDOW_DETAILS;

Dependencies

[top of page]

SYS.DBA_SCHEDULER_WINDOW_DETAILS references the following:

SchemaSYS
TableSCHEDULER$_EVENT_LOG
TableSCHEDULER$_WINDOW_DETAILS
SYS.DBA_SCHEDULER_WINDOW_DETAILS is referenced by following:

SchemaPUBLIC
SynonymDBA_SCHEDULER_WINDOW_DETAILS
SchemaSYS
ViewALL_SCHEDULER_WINDOW_DETAILS