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?
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
Explanation:
Exhibit Reference: 1Z0-033, 9i Performance Tuning, Question/Answer
SYBEX Oracle 1Z0-053 Study Guide, Chapter 11: Managing Database Resources
The validation process verifies that any changes in the pending area will not result in a violation of
any of the rules, such as the following:
There must be a plan directive for the OTHER_GROUPS group to allocate resources for sessions
not identified in the active plan.
Oracle Press 1Z0-053 Exam Guide, Chapter 12: Disk Space and Resource Management
Remember that your plan must include OTHER_GROUPS so that users other than those in the
consumer groups assigned to the [PLAN NAME] plan will have some resources available when
the plan is activated. Therefore, create one more plan directives for the [PLAN NAME] plan that
includes OTHER_GROUPS.