Oracle PL/SQL for DBAs

Name

DBA_SCHEDULER_WINDOWS

Synopsis

This view shows the windows defined in the database.

Column name	Description
WINDOW_NAME	Name of the window.
RESOURCE_PLAN	Name of the Resource Manager plan associated with the window.
SCHEDULE_OWNER	If the window has a named schedule, this column shows the name of the owner of the schedule.
SCHEDULE_NAME	Name of the schedule, if any.
START_DATE	Timestamp when the window will open. This is effective only when the window’s calendar properties are provided inline, not via a schedule. Shown in the TIMESTAMP(6) WITH TIMEZONE datatype.
REPEAT_INTERVAL	If the window has an inline calendar string, not a named schedule, the calendar string is shown here. (See the section "Calendar Strings" in Chapter 8.)
END_DATE	When a window has an inline schedule (calendar string, not a named schedule), this specifies the timestamp when the window will close permanently. Shown in the TIMESTAMP(6) WITH TIMEZONE datatype.
DURATION	How long the window is open. Shown in the DURATION datatype.
WINDOW_PRIORITY	When two windows overlap, the one with the higher priority will be opened, and the other one will be closed. The priorities are shown as HIGH and LOW.
NEXT_START_DATE	Next timestamp the window is scheduled to open. Shown in the TIMESTAMP(6) WITH TIMEZONE datatype.
LAST_START_DATE	Timestamp of the last time the window was opened. Shown in the TIMESTAMP(6) WITH TIMEZONE datatype.
ENABLED	Specifies whether a window is enabled (TRUE/FALSE).
ACTIVE ...