Identify the action that you CANNOT perform using Database Resource Manager.
A.
Define Consumer Groups.
B.
Create rules to map sessions to Consumer Groups.
C.
Define a Resource Plan.
D.
Allocate individual CPUs to Consumer Groups.
Explanation:
Oracle Database Resource Management (DRM) provides tools that allow any
Oracle DBA to manage a database server’s CPU resources effectively for application user groups
and during different resource demand periods.
DRM consists of four basic components:
*Resource Consumer Groups (not A). A resource consumer group is a collection of users with
similar requirements for resource consumption. Users can be assigned to more than one resource
consumer group, but each user’s active sessioncan only be assigned to one resource consumer
group at a time.
*Resource Plans (not C). In its simplest form, a resource plan describes the resources allocated to
one or more resource consumer group(s).
*Resource Plan Directives (not B). Resource plan directives allocate resources among the
resource consumer groups in the resource plan. Essentially, directives connect resource
consumer groups or subplans to their resource plans.
* SYSTEM_PLAN. Oracle supplies an initial, default resource plan named SYSTEM_PLAN. This
plan implements a CPU utilization resource allocation method to divide and prioritize CPU
resources to three resource consumer groups
B