Oracle Resource Manager Setup

Oracle Resource Manager is a technique to allocate resources to various processes in the database based on priorities set by business rules. With this you can say, set maximum CPU used by your batch processes, thereby reducing the liklihood of a run-away batch consuming all of the CPU and hence causing major issues with live OLTP traffic (which may be your revenue earner).

Resource Manager is one of the most underutilized yet very important database functionality. Many times in a heavily accessed database, you find that a new process or a job has been running for a long time due to some un-tuned SQL or PL/SQL. This results in this process using most of the available CPU. In such situations, it is paramount, that we use Resource Manager to allocate resources (CPU, Disk etc) in a way which is decided by business. e.g. Business may decide to give 90% of available CPU to the main traffic and leave 10% for all the batch jobs and non-critical processes.

Once Resource Manager is set properly, even if any un-tuned SQL hits the database, it cannot cause major downtime, since the Resource Manager setting limits the resources this wayword process can ever use.

This note discusses step by step way to setup Oracle Resource Manager to set up quotas on server resources for critical and non-critical operations. It is a simple way to gain experience setting up and playing around with resource manager.

Our personal notes provide you a very clear and step by step instructions to set up Oracle Resource Manager. Note that we use these notes only to setup Oracle Resource Manager in our test environments, so it really works! Once you have followed and setup Oracle Resource Manager, you can try all your commands you have been waiting for.

Go to the next page and you can see our entire catalogue of Database Study material list