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. ... |