Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 









Procedure to Implement and Manage DRM

Oracle RAC Cluster Tips by Burleson Consulting

This is an excerpt from the bestselling book Oracle Grid & Real Application Clusters.  To get immediate access to the code depot of working RAC scripts, buy it directly from the publisher and save more than 30%.

To administer the DRM, Oracle has provided many procedures available through the package dbms_resource_manager. This section gives a brief overview of the steps involved in implementing the database resource management.

To create a simple single-level resource plan with specified allocation methods, use create_simple_plan will typically be used and resource groups assigned.

In order to create a complex or multi-level plan, the following stages will be implemented.

* Create a Pending Area for creating plan schemas.  The procedure create_pending_area will be used.

* Create Resource Plans using the procedure create_plan.

* Create Consumer Resource Groups using the procedure create_consumer_group.

* Specify the Resource Plan directives using the procedure create_plan_directive.

Once the resource plans and resource consumer groups are defined and validated, they are submitted to make them active.

Before using the DRM facility, resource groups have to be assigned to the users or schemas. In earlier versions, until the 9i release, the consumer resource groups were manually assigned users. It was also possible to switch a user session to another resource group by using the procedures available in the dbms_resource_manager package.

These procedures are as follows:

* The user?s initial consumer group is automatically set to default_consumer_group when the user is created.

* The set_initial_consumer_group procedure can be used to switch to a specific consumer group.

* The switch_current_consumer_group can be used to change the current resource consumer group of a user?s current session.

* The procedure switch_consummer_group_for_sess causes the specified session to immediately be moved into the specified resource consumer group.

* switch_consumer_group_for_user can be used to change the resource consumer group for all sessions with a given user name.

Now, with the release of 10g, there are more options for assigning the resource groups to the sessions automatically. With the new features available in 10g, it now becomes possible to configure DRM to automatically assign the consumer groups to sessions. Creating mappings between the session attributes and consumer groups does this. It is also possible to prioritize these mappings and create precedence in the event of conflicts.

There are basically two types of session attributes that control the assignment of the resource group: login attributes and run-time attributes. The login attributes are evaluated at the time of session login, based on their appropriate resource group as assigned to the session. A session that is already up and running can be assigned to a different resource consumer group. Both these changes take place automatically. This provision of automatic mapping provides better control of resource usage and changes can be effected without the intervention of the administrators. It becomes possible to embed the directives in the application code itself. Based on the application needs, type of client program, operating system user level, and the client machine, the resource groups can be assigned and re-assigned.

There is a new procedure called set_group_mapping within the dbms_resource_manager that helps to map the session attributes to a consumer group. These attributes are of two types: login attributes and runtime attributes.


This is an excerpt from the bestselling book Oracle Grid & Real Application Clusters, Rampant TechPress, by Mike Ault and Madhu Tumma.

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.


Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational