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 









Managing Grid Using Grid Control (OEM)

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%.

Grid Control is utility that manages, monitors many diverse resources with in the enterprise grid. Such resources include, Database Systems, Hosts (blades/servers), application servers, web applications and storage devices. It is also extensible, so that extra components that are not supported out of the box can be added. From a single place, Grid control allows the comparison of performance levels of various comparable resources.

Grid Control can do the day-to-day management or administration on all these controlled resources. As the performance metrics are analyzed in a certain time frames, the inter-relations between the related resources can be easily understood, which leads to better problem solutions. More details on using the Grid Control Utility in the chapter in this book on Using Grid Control Utility.

Oracle Resource Manager

Database Resource Manager (DRM) provides the resource management facilities. In a database instance, which is highly active and concurrently accessed by large numbers of users, control of suitable resource allocation is essential. In the absence of a better resource control, some critical and high priority sessions or tasks may not get required resources in time. Oracle DRM is a framework that provides a mechanism to control the resource allocation.

The DRM helps to allocate a percentage of CPU time to different users, user groups, and applications. It can limit the parallelism of operation by allowing other competing processes to get their share of resources. It also can create resource pools, such as the undo pool and the active session pool that help control the execution resource availability for a group of sessions.

Components of DRM

There are three main components with which the DBA can define and manage resource allocation. They are:

* Resource Consumer Group: These are the named entities, which are groups of users or sessions combined together, based on their processing and resource needs.

* Resource Plan: Contains the directives that specify how the resources are allocated to the resource consumer groups.

* Resource Plan Directive: These are used to associate resource consumer groups with particular resource plans and allocate resources among the resource consumer groups.

The Oracle package dbms_resource_manager is used to create and maintain the resource plans and manage the resource consumer groups.

Resource and Plan Directives

The resource plan can be a single-level resource plan or it can be a multi-level resource plan. In a single-level resource plan, the resources are allocated among the associated resource groups. For example, the policy_rec plan allocates CPU resources among the three consumer groups viz., claims, sales, and legal. The resource group claims gets 55% of CPU time, sales gets 25%, and legal receives 20% of CPU time.

In a multi-level resource plan, sub-plans represent a hierarchy of plans and their associated resource groups. The policy_rec provides for two sub-plans, sales and claims, and one resource group named legal. The claims sub-plan allocates 60% of CPU time to the resource group called LIFE and 40% to the group called AUTO. The sales sub-plan allocates 70% of CPU time to the resource group called NEWSALES and 30% to the group called MARKET.

The resource plan directives specify how the resources are allocated to resource consumer groups. There are many resources involved in the database activity, which can be controlled by DRM. The resources include CPU availability for the competing resource groups, the number of simultaneous active sessions allowed within a consumer group, the degree of parallelism, the execution time limit, and the undo pool.


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