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;