Resource Plan Related To Window Is Not Clear After Closing Corresponding Window On RAC
Last updated on JUNE 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.2 to 12.2]
Information in this document applies to any platform.
Resource plan related to window is not clear after closing corresponding windoweven after applying 13817037
One of the databases having the issue is named "test01" and it has two instances, "test01p1" and "test01p2".
The resource_manager_plan parameter has a value test01_INITIAL_PLAN in spfile for all the instances.
When daily maintenance window closes, one of the instances goes back to the resource manager plan specified in the parameter (test01_INITIAL_PLAN) but the other one clears the resource manager plan so it ends up using the INTERNAL_PLAN.
However both of the instances should remain with "test01_INITIAL_PLAN" (because that is what the resource_manager_plan parameter is configured to in both instances) after the maintenance window closes.
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