Applies to:Oracle Server - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Jul-2012***
Oracle 10g, does not have pre-defined settings regarding resource manager and therefor the jobs will be run under the consumer group credentials of the user SYS or even worse in the OTHER_GROUPS consumer group.
As of Oracle 11g, the default maintenance window linked to the jobs will automatically switch the database into the DEFAULT_MAINTENANCE_PLAN plan and switych back to the original plan once the window has been closed.
While the credentials specified in the DEFAULT_MAINTENANCE_PLAN plan is suited for most database, some high demand environment such as 24*7 activity have the need to plan maintenance resources in a more intelligent manor. This article will illustrate how this can be achieved
First identify the job class and its consumer group linked to a specific job:
Option 1: Use Existing Job Class Consumer Group
1. Assign the required resource to the AUTO_TASK_CONSUMER_GROUP in your existing resource manager plan
2. Grant switch privileges to the user SYS for this consumer group:
Option 2: Create your own job class
1. Create your own job class and assign the desired consumer group. In this example I use RM_BATCH_GROUP which is assigned 50% of the CPU at level 2
2. Modify the job to reflect the new job class