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=>’O
LTP’,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.
Wrong (again! lol)
Right answer is D
Check here : http://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN11844
OTHER_GROUPS
This consumer group contains all sessions that have not been assigned to a consumer group. Every resource plan must contain a directive to OTHER_GROUPS.
About Resource Consumer Groups
A resource consumer group (consumer group) is a collection of user sessions that are grouped together based on their processing needs. When a session is created, it is automatically mapped to a consumer group based on mapping rules that you set up. As a database administrator (DBA), you can manually switch a session to a different consumer group. Similarly, an application can run a PL/SQL package procedure that switches its session to a particular consumer group.
Because the Resource Manager allocates resources (such as CPU) only to consumer groups, when a session becomes a member of a consumer group, its resource allocation is determined by the allocation for the consumer group.
There are special consumer groups that are always present in the data dictionary. They cannot be modified or deleted. They are:
SYS_GROUP
This is the initial consumer group for all sessions created by user accounts SYS or SYSTEM. This initial consumer group can be overridden by session-to–consumer group mapping rules.
OTHER_GROUPS
This consumer group contains all sessions that have not been assigned to a consumer group. Every resource plan must contain a directive to OTHER_GROUPS.
There can be no more than 28 resource consumer groups in any active plan.
Thanks Vonpire!
D tested
SQL> execute 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>
SQL> EXECUTE 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
SQL>
How to create RESOURCE PLAN is here
http://apunhiran.blogspot.com/2011/01/how-to-setup-resource-manager-to_14.html
D
D