Problems with Resource Manager

There are a few things to keep in mind when you want to make real use of the Scheduler and want it to be controlled by Resource Manager. Sometimes it so happens that a system is idle, which means it's not using much CPU, and still your jobs are not started. Or it could also be that all of a sudden the jobs stop getting started without any modification of jobs or resource plans at all. These are nasty situations. To start with, make sure that every patch for Resource Manager is applied. For Oracle 10.2.0.4, start with the patch for bug 7482069, which is a collection of fixes for Resource Manager and is generic for all platforms.

Also, check the alert log during instance start and also check if the NUMA setting fits your system. By default, Oracle enables NUMA optimization in 10.2.0.4. This can have side effects that are not always positive, especially when your system does not happen to be a NUMA system. NUMA stands for Non Uniform Memory Architecture, which...