QUESTION 17
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 theresources plan directive
C. The SYS_GROUP resource consumer group is not includedin the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
Answer: D
同99题:http://blog.csdn.net/rlhua/article/details/18795859
Explanation/Reference:
Section: Database Architecture & Resource Management, RAC, ASM
D is correct
Exhibit Reference:1Z0-033, 9i Performance Tuning, Question 146 of 164- Exact Question/Answer
SYBEX Oracle 1Z0-053 Study Guide, Chapter 11: Managing Database Resources
The validation process verifies that any changes inthe 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.