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?
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
Explanation:
B: Job priorities are used only to prioritize among jobs in the same class.
Note: Group jobs for prioritization
Within the same job class, you can assign priority values of 1-5 to individual jobs so that if two jobs in the class
are scheduled to start at the same time, the one with the higher priority takes precedence. This ensures that
you do not have a less important job preventing the timely completion of a more important one.
C: Set resource allocation for member jobs
Job classes provide the link between the Database Resource Manager and the Scheduler, because each job
class can specify a resource consumer group as an attribute. Member jobs then belong to the specified
consumer group and are assigned resources according to settings in the current resource plan.