Which two actions would reduce the job’s elapsed time?

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?

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *