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

Get Mastering Oracle Scheduler in Oracle 11g Databases now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.