Summary

Resources should be managed using the Resource Manager. When jobs are controlled by individual schedules, a lot can be done manually by making sure that plenty of resources are always available.

When jobs are controlled by a window, it is very important to have a good Resource Manager plan in place. Otherwise, all the jobs that have been submitted will flood the system at window open time—causing lots of waits and, most likely, lots of trouble. The goal for the Resource Manager is to make the jobs go in the fastest possible way through the system. Other things we have seen are:

• How to create a resource consumer group

• How to grant privileges to switch a resource consumer group to a user

• How to couple a job_class to a resource consumer group

• How to couple a job_class to an existing job

• How to create a Resource Manager plan using DB Console

• How to control the number of active sessions to be equal to the number of jobs in a Resource Manager plan using the session pool

• How to control the maximal...