OCP CBT Question 683
Please solve the following question.
You have configured a complex resource plan named `PARENT_PLAN` which includes a subplan named `BATCH_SUBPLAN`. The `BATCH_SUBPLAN` itself contains directives for `BATCH_GROUP_A` and `BATCH_GROUP_B`. You have defined `MAX_UTILIZATION_LIMITS` for `BATCH_SUBPLAN` in `PARENT_PLAN`. If `BATCH_SUBPLAN` reaches its `MAX_UTILIZATION_LIMITS` for CPU, what will be the immediate effect on sessions in `BATCH_GROUP_A` and `BATCH_GROUP_B`?
Resource Plan Structure
-- PARENT_PLAN Directives
BEGIN
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
PLAN => 'PARENT_PLAN', GROUP_OR_SUBPLAN => 'OLTP_GROUP', MGMT_PERCENT => 70);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
PLAN => 'PARENT_PLAN', GROUP_OR_SUBPLAN => 'BATCH_SUBPLAN', MGMT_PERCENT => 30, MAX_UTILIZATION_LIMITS => 'CPU:100');
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
PLAN => 'PARENT_PLAN', GROUP_OR_SUBPLAN => 'OTHER_GROUPS', MGMT_PERCENT => 0);
END;
/
-- BATCH_SUBPLAN Directives
BEGIN
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
PLAN => 'BATCH_SUBPLAN', GROUP_OR_SUBPLAN => 'BATCH_GROUP_A', MGMT_PERCENT => 60);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
PLAN => 'BATCH_SUBPLAN', GROUP_OR_SUBPLAN => 'BATCH_GROUP_B', MGMT_PERCENT => 40);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
PLAN => 'BATCH_SUBPLAN', GROUP_OR_SUBPLAN => 'OTHER_GROUPS', MGMT_PERCENT => 0);
END;
/