OCP 1Z0 053 99

99.View the Exhibit and examine the steps that you executed to create a database resource plan. 
Subsequently, you execute the following procedure which results in an error: 
SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); 
What could be the reason? 
Exhibit: 

A. The pending area is automatically submitted after the plan creation 
B. The procedure must be executed before creating the resources plan directive 
C. The SYS_GROUP resource consumer group is not included in the resource plan directive 
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive 
Answer: D 

SQL> execute dbms_resource_manager.create_pending_area();
PL/SQL procedure successfully completed

SQL> execute dbms_resource_manager.create_consumer_group(consumer_group => 'OLTP',comment => 'Online users');
PL/SQL procedure successfully completed

SQL> execute dbms_resource_manager.create_plan(plan => 'PRIUSERS',comment => 'DSS/Batch priority,...');
PL/SQL procedure successfully completed

SQL> execute dbms_resource_manager.create_plan_directive(plan => 'PRIUSERS',group_or_subplan => 'OLTP',comment => 'Online users',cpu_p1 => 60);
PL/SQL procedure successfully completed

SQL> EXECUTE dbms_resource_manager.validate_pending_area();
begin dbms_resource_manager.validate_pending_area(); end;
ORA-29382: 暂挂区验证失败
ORA-29377: 使用者组 OTHER_GROUPS 不是最高级计划 PRIUSERS 的组成部分
ORA-06512: 在 "SYS.DBMS_RMIN", line 444
ORA-06512: 在 "SYS.DBMS_RESOURCE_MANAGER", line 815
ORA-06512: 在 line 1

相关内容见

http://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm#ADMIN027