Which of the following Resource Manager rules must be validated with the DBMS_RESOURCE_MANAGER.
A. The plan must have a directive for SYSTEM_GROUP.
B . The plan must have a directive for OTHER_GROUPS.
C . No subplan loops.
D . The plan must have a directive for SYS_GROUP.
E. Each subplan must reference the top-level plan's consumer group.
Explanation:
Answer A and E: Resource Manager consumer groups are user-defined (or DBA-defined) defined groups of schema users that have similar resource requirements. The DBA can assign a user to as many consumer groups as is required. A session logs on with the default consumer group for the user, and the user session can then switch to other allowed consumer groups as needed.
No comments:
Post a Comment