A Database Resource manager plan includes which three attributes?
A.
Database names, levels and allocations
B.
Database names, levels, and resource groups
C.
Database names, allocations and resource groups
D.
Database names, resource groups, and categories
Explanation:
Resource plans specify the resource consumer groups belonging to the plan and
contain directives for how resources are to be allocated among these groups. You use the
DBMS_RESOURCE_MANAGER package to create and maintain these elements of the Database
Resource Manager: resource plans, resource consumer groups, and resource plan directives.
Plan information is stored in tables in the data dictionary. Several views are available for viewing
plan data.
How resources are allocated to resource consumer groups is specified in resource allocation
directives. The Database Resource Manager provides several means of allocating resources.
Note: The main goal of the Database Resource Manager is to give the Oracle Database server
more control over resource management decisions, thus circumventing problems resulting from
inefficient operating system management.