What is a Database Resource Manager (DRM)?

What is a Database Resource Manager (DRM)?

Rating:

Database Resource Manager (DRM) is a tool, which handles the resource allocation issues in a more efficient way than can probably be done by the operating system itself. This tool has been provided with all versions after Oracle7i. Before the introduction of this feature, resource management was only possible through the use of profiles. Following are some of the tasks that can be performed by the DRM:

• Creating resource consumer groups and limiting the number of resources on each such group (Every user application is attached with a resource consumer group. Hence, each application has an upper limit on the number of resources that can be allocated to it).
• Distributing the processing time by allocating percentage of CPU time to each user application (The DRM does the processing distribution in a more effective way than the operating system by allocating the CPU time on a priority basis).
• Placing an upper limit on the number of user sessions that can be concurrently executed within a resource group.
• Controlling the degree of parallelism of every transaction that is carried out by users of a resource consumer group.

Rating: