My Oracle Support Banner

Primary Note: Overview of Oracle Resource Manager and DBMS_RESOURCE_MANAGER (Doc ID 1484302.1)

Last updated on SEPTEMBER 04, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


The Oracle Database Resource Manager is a tool for managing how multiple consumer groups (i.e. workloads) or databases use and share resources, such as CPU, I/O, and parallel servers.

The purpose of this Document is to provide detailed explanation and usages of Oracle Database Resource Manager ( DBRM ) and  RESOURCE_MANAGER_PLAN.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Setup and Configuration
 Resource Manager Administration Privileges
 Resources Managed by the Resource Manager
 Elements of the Resource Manager
 Enabling the Database Resource Manager
 Getting Started with Resource Manager
 Create Simple Resource Plan using CREATE_SIMPLE_PLAN procedure
 Create Complex Resource Plan using CREATE_PLAN procedure
 Checking Configuration and Monitoring Resource Manager 
 Cleaning the Resource Manager Plan
 Applications of Resource Manager (Additional Examples/Samples)
 12c: Using Oracle Resource Manager on pluggable databases (PDBs) in a multitenant container database (CDB)
 Oracle Resource Manager and Operating System (OS) Resource manager
 Oracle Database Services and Resource Manager
 Troubleshooting/Known Issues
 Recommended Patches

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.