Oracle PL/SQL for DBAs

Getting Information About Windows

You can obtain information about windows in the database from the view DBA_SCHEDULER_WINDOWS. Here are the important columns of the view.

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 is 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. Shows the date in the TIMESTAMP(6) WITH TIME ZONE datatype.
REPEAT_INTERVAL	If the window has an inline schedule (calendar string, as opposed to a named schedule), this is the calendar string.
END_DATE	When a window has an inline schedule (calendar string, as opposed to a named schedule), this specifies the timestamp when the window will close permanently. Similar to start_date, this column shows the date in the TIMESTAMP(6) WITH TIME ZONE 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. Shows the date in the datatype TIMESTAMP(6) WITH TIME ZONE.
LAST_START_DATE	Timestamp of the last time the window was opened. ...