Skip to Main Content
Oracle PL/SQL for DBAs
book

Oracle PL/SQL for DBAs

by Arup Nanda, Steven Feuerstein
October 2005
Intermediate to advanced content levelIntermediate to advanced
454 pages
14h 44m
English
O'Reilly Media, Inc.
Content preview from 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. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Best Practices

Oracle PL/SQL Best Practices

Steven Feuerstein
Expert Oracle PL/SQL

Expert Oracle PL/SQL

Ron Hardman, Michael McLaughlin
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 0596005873Supplemental ContentErrata Page