nerdexam
Oracle

1Z0-515 · Question #36

Identify the action that you CANNOT perform using Database Resource Manager.

The correct answer is D. Allocate individual CPUs to Consumer Groups. 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…

Advanced Concepts

Question

Identify the action that you CANNOT perform using Database Resource Manager.

Options

  • ADefine Consumer Groups.
  • BCreate rules to map sessions to Consumer Groups.
  • CDefine a Resource Plan.
  • DAllocate individual CPUs to Consumer Groups.

How the community answered

(41 responses)
  • A
    15% (6)
  • B
    7% (3)
  • C
    5% (2)
  • D
    73% (30)

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 session can 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

Topics

#Database Resource Manager#consumer groups#resource plan#CPU allocation

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice