How to Change The Automated Maintenance Tasks Weekend Schedule (Doc ID 2036557.1)

Last updated on DECEMBER 07, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 07-Dec-2016***

Goal

The Automated Maintenance Tasks Runs by Default in the Predefined Maintenance Windows .

Assuming Saturday and Sunday as weekend , typically below are the default schedules in the database:

 

Window Name Description
MONDAY_WINDOW Starts at 10 p.m. on Monday and ends at 2 a.m
TUESDAY_WINDOW Starts at 10 p.m. on Monday and ends at 2 a.m
WEDNESDAY_WINDOW Starts at 10 p.m. on Monday and ends at 2 a.m
THURSDAY_WINDOW Starts at 10 p.m. on Monday and ends at 2 a.m
FRIDAY_WINDOW Starts at 10 p.m. on Monday and ends at 2 a.m
SATURDAY_WINDOW Starts at 6 a.m. on Saturday and is 20 hours long
SUNDAY_WINDOW Starts at 6 a.m. on Saturday and is 20 hours long

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms