Database Administration (MOSC)

MOSC Banner

activate resource manager plan with window

edited Aug 15, 2017 4:31PM in Database Administration (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center