Oracle Database 12c Advance Adminstration1z0-063 Test 2

Question : 14 of 40

Marks: +1, -0

View the Exhibit showing steps to create a database resource manager plan.

SQL>execute dbms_resource_manager.create_pendingarea(); 
 PL/SQL procedure successfully completed. 
 SQL>exec dbms_resource_manager, create_consumergroup (consumer_group=>’OLTP,,comment=>,onlineuser’) 
 PL/SQL procedure successfully completed. 
 SQL>exec bras resource_manager.create plan(plan=>’PRIU3ER3',comment=>'dssprio’); 
 SQL>exec 
 Dbms_resource_manager.create_plan_directive(plan=>’PRIU3ER3’,group_or_subplan=>'OLTP’,comment=>'onlinegrp'CPU_Pl=>60); 
 PL/3QLproceduresuccessfullycompleted.

After executing the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTE dbms_resource_manager. validate_pending_area ();

The pending area is automatically submitted when creating plan directives.
The procedure must be executed before creating any plan directive.
The sys_group group is not included in the resource plan.
The other_groups group is not included in the resource plan.
Pending areas can not be validated until submitted.

Validate

Go to Question:

Prev Question

Next Question