Resource Plan Related To Window Is Not Clear After Closing Corresponding Window On RAC
(Doc ID 2404055.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!