ALL_SCHEDULER_WINDOW_DETAILS

ALL_SCHEDULER_WINDOW_DETAILS displays log details for the Scheduler windows accessible to the current user.

Related View

DBA_SCHEDULER_WINDOW_DETAILS displays log details for all Scheduler windows in the database.


Column Datatype NULL Description

LOG_ID

NUMBER

 

Unique identifier of the log entry (foreign key of the *_SCHEDULER_WINDOW_LOG views)

LOG_DATE

TIMESTAMP(6) WITH TIME ZONE

 

Date of the log entry

OWNER

VARCHAR2(128)

 

Owner of the Scheduler window

WINDOW_NAME

VARCHAR2(261)

 

Name of the Scheduler window

REQ_START_DATE

TIMESTAMP(6) WITH TIME ZONE

 

Requested start date for the Scheduler window

ACTUAL_START_DATE

TIMESTAMP(6) WITH TIME ZONE

 

Actual start date of the Scheduler window

WINDOW_DURATION

INTERVAL DAY(3) TO SECOND(0)

 

Requested duration of the Scheduler window

ACTUAL_DURATION

INTERVAL DAY(3) TO SECOND(0)

 

Actual duration for which the Scheduler window lasted

INSTANCE_ID

NUMBER

 

Identifier of the instance on which the window was run

ADDITIONAL_INFO

VARCHAR2(4000)

 

Additional information on the entry, if applicable