Chapter 4. Managing Resources

We use Oracle's Resource Manager to manage resources. If a system contains only a few jobs, it might not be worth setting this up. However, for any system where thousands of jobs run concurrently with online users, setting this up makes absolute sense. Resource Manager is the key to Oracle Instance Consolidation—one of the more extreme cost optimization techniques available that is often neglected. Online users don't want to be slowed down because of long-running batches. At the same time, they are waiting for the results of these batches; so the batches need to run as quickly as they can. Traditionally, administrators would often make plans for daily usage by online users and separate plans for nightly usage. In our current 24-hour global economy, this no longer makes sense and is unnecessary. If Resource Manager does its job the way it should, there is no longer a need to switch to a nightly plan where the batches have more resources. If there are no online...