Database, SQL and PL/SQL

Configure and Create Resource Manager Plans

Test your knowledge of Oracle Database’s Resource Manager in Oracle Database 12c.

By Joel Goodman

January/February 2017

Oracle Database’s Resource Manager feature is used to limit resource utilization and define minimum service levels for CPU and I/O. This column contains sample questions, answers, and explanations about Resource Manager, including functionality available in Oracle Database 12c. The sample questions are of the type you may encounter when taking the "Oracle Database 12c: Installation and Administration" (1Z0-062), "Upgrade to Oracle Database 12c" (1Z0-060), or "Oracle Database 12c: Performance Management and Tuning" (1Z0-064) exam.

Configure Resource Manager

Resource Manager may be configured from the command line or with GUI tools. For groups of database sessions known as "resource consumer groups," Resource Manager supports the use of limits on certain resources, and it also can define minimum resource availability for CPU and I/O bandwidth. Resource Manager allocates resources to consumer groups according to the set of resource plan directives for the currently active resource plan.

Oracle Database 12c supports all the features of Resource Manager from earlier database releases as well as the new Oracle Multitenant architecture introduced in Oracle Database 12c.

Question 1

For which three purposes would you use Resource Manager?

a. Limiting the CPU used per consumer group session

b. Specifying the maximum number of concurrent sessions that may have a call executing

c. Specifying the amount of memory a session can allocate from the large pool

d. Limiting the degree of parallelism of operations performed by a consumer group

e. Specifying an idle-time limit that applies to idle sessions that are not blocking other sessions

Question 2

Which three statements are true about Resource Manager?

a. It can take action for I/O-intensive sessions only after a specified number of physical I/Os is reached.

b. It can limit the amount of undo used by a consumer group.

c. A resource plan must always have a plan directive for a "catchall" group called OTHER_GROUPS.

d. A resource plan change can be done automatically by Oracle Database.

e. It can automate the switching of a consumer group for a session but cannot switch the session back to its original consumer group.

f. It can limit the amount of undo used by each session in a consumer group.

Create Resource Plans for Multitenant Databases

Oracle Database 12c supports Resource Manager plans for pluggable databases (PDBs) in an Oracle Multitenant environment in addition to the plans it supports when Oracle Multitenant is not used.

Question 3

Which three resources might be prioritized between competing PDBs when a multitenant container database (CDB) plan is created with Resource Manager?

a. Maximum number of logical I/Os done by a PDB

b. Maximum number of physical I/Os done by a PDB

c. Parallel servers per PDB

d. CPU used by a PDB

e. Maximum number of PDBs for a CDB

Question 4

Which two statements are true about Resource Manager PDB resource plans in a multitenant CDBs?

a. If no PDB plan is enabled for a specific PDB, then all sessions for that PDB get resources prioritized by length of session.

b. To enable a PDB plan, a CDB plan must be created and enabled.

c. If a PDB plan is enabled for at least one PDB, then the CDB plan may not be disabled.

d. A PDB plan may be disabled.

e. A CDB plan may be enabled even if no PDBs have enabled PDB plans.

Next Steps

LEARN more about the Oracle Certification Program.

Oracle Database Administrator’s Guide, “Managing Resources with Oracle Database Resource Manager.”
Oracle PL/SQL Packages and Types Reference, “DBMS_RESOURCE_MANAGER.”

EXPLORE Inside OCP columns.

Photography by Scott Webb, Unsplash