4.65 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