Setting the Resource Plan for an Instance
4.
Specify the plan to be used by the instance.
–
Specify the RESOURCE_MANAGER_PLAN
initialization parameter.
–
Change the resource plan without shutting
down and restarting the instance.
ALTER SYSTEM
SET RESOURCE_MANAGER_PLAN=night;