1Z0-060 · Question #194
You notice that the elapsed time for an important database scheduler job is unacceptably long. The job belongs to a scheduler job class and runs in a scheduler window. Which two actions could reduce…
The correct answer is A. Increasing the job's relative priority within the Job class to which it belongs C. increasing resource allocation for the consumer group mapped to the job class in the resource. Raising a job's intra-class scheduling priority or increasing its consumer group's Resource Manager allocation are the two direct mechanisms for reducing a scheduler job's elapsed time.
Question
You notice that the elapsed time for an important database scheduler job is unacceptably long. The job belongs to a scheduler job class and runs in a scheduler window. Which two actions could reduce the job's elapsed time?
Options
- AIncreasing the job's relative priority within the Job class to which it belongs
- BIncreasing the priority of the scheduler window to which the job belongs
- Cincreasing resource allocation for the consumer group mapped to the job class in the resource
- DMoving the job to an existing higher priority scheduler window with the same schedule and
- EIncreasing the value of the JOB_QUEUE_PROCESSES parameter
How the community answered
(40 responses)- A78% (31)
- B3% (1)
- D13% (5)
- E8% (3)
Why each option
Raising a job's intra-class scheduling priority or increasing its consumer group's Resource Manager allocation are the two direct mechanisms for reducing a scheduler job's elapsed time.
The RELATIVE_PRIORITY attribute of a job within its job class determines which job the scheduler favors when multiple jobs compete for execution slots; increasing it causes the scheduler to dispatch this job before lower-priority peers, reducing its queue wait and overall elapsed time.
Scheduler window priority governs only which window becomes active when two windows overlap; it does not affect resource allocation or job execution order within an already-active window and therefore cannot reduce the job's elapsed time.
Oracle Scheduler job classes map to Resource Manager consumer groups; increasing the CPU and I/O shares allocated to the consumer group associated with the job's class directly provides more system resources per unit time to the job, shortening its execution duration.
Moving the job to a higher-priority window that carries the same schedule means the window activates at the same time as before, leaving the job's start time and available resources unchanged - no elapsed-time reduction results.
JOB_QUEUE_PROCESSES sets the maximum number of J-series background processes available for running all scheduled jobs concurrently; it improves overall job throughput but does not allocate additional CPU or I/O to a specific individual job, so it cannot reduce that job's elapsed time.
Concept tested: Oracle Scheduler job priority and Resource Manager consumer group tuning
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/oracle-scheduler-concepts.html
Topics
Community Discussion
No community discussion yet for this question.