You can view the details of each scheduled maintenance window, including how often each window occurs, its start time, and duration.
To view maintenance window scheduling details
Log in as user oracle on an AS3000 machine, or as the AgfaService user on AS300 Oracle on Windows.
To start a sqlplus session, type
sqlplus / as sysdba
To see the windows in the Maintenance Window Group, type
select * from DBA_SCHEDULER_WINGROUP_MEMBERS where WINDOW_GROUP_NAME = 'MAINTENANCE_WINDOW_GROUP';
The query result returns the windows that are included in the Maintenance Window Group:
To view the details of each maintenance window, type
select window_name, repeat_interval, duration from dba_scheduler_windows where window_name in ('WEEKNIGHT_WINDOW', 'WEEKEND_WINDOW');
This query returns the maintenance window is scheduled, and its duration:.
In this example, the weeknight window begins at 22:00 hours each weekday, and lasts a maximum of eight hours. The weekend window begins Saturdays at midnight and runs for a maximum of 2 days, covering both Saturday and Sunday.
To log out of sqlplus, type
exit