Database Resource Manager

This is a work in progress. Help us to improve this page or provide feedback on the discussion page. Expect this article to change frequently.

The Database Resource Manager (DRM) provides database resource management capability for the Oracle Database. The DRM is administered by the PL/SQL Package DBMS_RESOURCE_MANAGER while the necessary privileges are controlled by the DBMS_RESOURCE_MANAGER_PRIVS package. More easily the DRM can be managed via Oracle Enterprise Manager.

Note that whatever is the configuration you give, Resource Manager comes into play only if your server CPU is busy at 100% and there are processes waiting for it.

Elements

Element	Description
Resource consumer group	Groups user sessions together based on resource processing requirements.
Resource plan	Assigns resources to resource consumer groups.
Resource allocation method	Method/policy used by DRM to allocate a particular resource. Is used by resource consumer groups and resource plans.
Resource plan directive	Used to assign particular resource plans to resource consumer groups and to further detail them.

History

DRM was first introduced with Oracle 8i (8.1.5) in February 1999.

External Links

Chapters about Database Resource Manager in:

• Oracle Database Administrator's Guide, 11g Release 2 (11.2)
• Oracle Database Administrator's Guide, 10g Release 2 (10.2)
• Oracle9i Database Administrator's Guide, Release 2 (9.2)
• Oracle8i Administrator's Guide, Release 2 (8.1.6)