[Home] [Help] [Dependency Information]
Object Name: | ALL_SCHEDULER_WINDOW_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
The details of a window
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 |
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.ALL_SCHEDULER_WINDOW_DETAILS;
|
|
|