How to Force RESOURCE_MANAGER_PLAN with the Scheduler window boundaries (Doc ID 1168574.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Jun-2016***

Goal

Creating resource manager plan

exec dbms_resource_manager.switch_plan( plan_name => 'GBS_LIMITS_PLAN' );
exec dbms_resource_manager.switch_plan( plan_name => 'GBS_LIMITS_PLAN', allow_scheduler_plan_switches => FALSE );

but some time, automatically resource manager switch to DEFAULT_MAINTENANCE_PLAN.

In DBA_SCHEDULER_WINDOWS i find this information

SQL> select window_name,RESOURCE_PLAN ,
2 from DBA_SCHEDULER_WINDOWS
3 /

WINDOW_NAME RESOURCE_PLAN
------------------------------ --------------------------
WEEKNIGHT_WINDOW DEFAULT_MAINTENANCE_PLAN
WEEKEND_WINDOW DEFAULT_MAINTENANCE_PLAN
MONDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
TUESDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
WEDNESDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
THURSDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
FRIDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
SATURDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
SUNDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
TEST_STAT_PROVA_WINDOW DEFAULT_MAINTENANCE_PLAN
CUSTOM_SMALL_MORNING_WINDOW DEFAULT_MAINTENANCE_PLAN
CUSTOM_SMALL_EVENING_WINDOW DEFAULT_MAINTENANCE_PLAN
CUSTOM_HUGE_WEEKEND_WINDOW DEFAULT_MAINTENANCE_PLAN

How to remove automatically switch ???

Need plan (called GBS_LIMITS_PLAN) to be always ON.

Should DBMS_SCHEDULER.drop_window be used for each WINDOW_NAME ???

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