View the Exhibit showing steps to create a database resource manager plan.
SQL>executedbms_resource_manager.create_pendingarea(); PL/SQLproceduresuccessfully completed.
3QL>execdbms_resource_manager,create_consumergroup (consumer_group=>’OLTP,,comment=>,onlineuser’) PL/SQLproceduresuccessfullycompleted.
SQL>execdbras_resource_raanager.create_plan(plan=>’PRIU3ER3′,comment=>’dssprio’);
SQL>exec
Dbms_resource_manager.create_plan_directive(plan=>’PRIU3ER3′,group_or_subplan=>’OLTP’,comraent=>’onlinegrp’CPU_Pl=>60);
PL/3QLproceduresuccessfullycompleted.
After execting the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTEdbms_resource_manager. validate_pending_area ();
What is the reason for the error?
A. The pending area is automatically submitted when creating plan directives.
B. The procedure must be executed before creating any plan directive.
C. The sys_group group is not included in the resource plan.
D. The other_groups group is not included in the resource plan.
E. Pending areas can not be validated until submitted.
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA();
PL/SQL procedure successfully completed.
SQL> EXEC DBMS_RESOURCE_MANAGER.create_consumer_group (consumer_group=> ‘OLTP’, comment => ‘online user’);
PL/SQL procedure successfully completed.
SQL> EXEC DBMS_RESOURCE_MANAGER.create_plan (plan=> ‘PRIUSER3’, comment=> ‘dssprio’);
PL/SQL procedure successfully completed.
SQL> EXEC DBMS_RESOURCE_MANAGER.create_plan_directive(plan=> ‘PRIUSER3’, group_or_subplan=> ‘OLTP’ ,comment => ‘onlinegroup’, CPU_P1=>60);
PL/SQL procedure successfully completed.
SQL> EXEC DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA();
BEGIN DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA(); END;
*
ERROR at line 1:
ORA-29377: consumer group OTHER_GROUPS is not part of top-plan PRIUSER3
ORA-06512: at “SYS.DBMS_RMIN_SYS”, line 3640
ORA-06512: at “SYS.DBMS_RMIN_SYS”, line 3691
ORA-06512: at “SYS.DBMS_RMIN_SYS”, line 3703
ORA-06512: at “SYS.DBMS_RESOURCE_MANAGER”, line 746
ORA-06512: at line 1