Upgrade to Oracle Database 12c — Question 26

You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time?

Answer options

• A. Increasing the priority of the job class to which the job belongs
• B. Increasing the job's relative priority within the Job class to which it belongs
• C. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
• D. Moving the job to an existing higher priority scheduler window with the same schedule and duration
• E. Increasing the value of the JOB_QUEUE_PROCESSES parameter
• F. Increasing the priority of the scheduler window to which the job belongs

Correct answer: B, C

Explanation

Option B is correct because increasing the job's relative priority within its Job class allows it to receive more CPU time, thus reducing elapsed time. Option C also contributes by enhancing resource allocation for the consumer group, which can improve performance. The other options do not directly address the job's specific execution context or would not provide the same level of improvement.