My Oracle Support Banner

Job Scheduler secondary are not mapped to proper Consumer Group (Doc ID 785541.1)

Last updated on JULY 09, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Problem prevents users from controlling the degree of parallelism of their batch jobs.

When they create a scheduler job to run their process code, they specify that the job run under specific Job Class.

That Job Class is associated with a Resource Consumer Group that is part of the active resource plan.

The Consumer Group Plan Directives which specify the degree of parallelism limits.
– one for parallel server limits which controls the degree of parallelism of parallel query/dml in the code
- and one for active session limit, which controls the number of threads spawned during process code is run

What occurs is the Job Class and Consumer Group mapping is INTERMITTENTLY ignored.

This causes scheduler job to run in the OTHER_GROUPS Consumer Group instead of the
consumer Group they specifically created.

To summarize, the Job Scheduler secondary are not getting mapped correctly to the corresponding resource Consumer Group.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.