activate resource manager plan with window
Hi,
I'm facing this problem of implementing resource manager in a 12.1.0.2 multitenant database. At cdb level we activate the default plan, and then at each pdb we have two plans, OLTP (from 9am to 6pm) and BATCH (from 6pm to 9am), and we defined two scheduler window in each pdb, window_oltp that activates OLTP plan and window_batch that activates BATCH plan.
We noticed that when windows open, it activates the plan, however if for instance at 10pm when the window_batch is active, we shutdown the database and restart it, then the window shows active but the plan BATCH is not active, the active plan is the one specified in the parameter resource_manager_plan (if specified, if not theres no plan). In this case we would like to have the plan specified in the window as active.