Oracle Database 12c: Installation and Administration — Question 124

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? (Choose two.)

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 compete more effectively for resources, thereby reducing its elapsed time. Option C is also correct because enhancing resource allocation for the consumer group linked to the job class can provide the job with more resources to execute faster. The other options do not directly address the job's execution parameters or may not have the same effect on reducing elapsed time.