QUESTION 74

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 t he job belongs

B. Increasing the job's relative priority within t he 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 t he same schedule and duration

E. Increasing the value of t he JOB_QUEUE_PROCESSES parameter

F. Increasing the priority of the scheduler window to which t he job belongs

Correct Answer: BC

Section: (none)

Explanation

Explanation/Reference:

B: Job priorities are used only to prioritize among jobs in t he same class.

Note: Group jobs for prioritization

Within t he same job class, you can assign priority values of 1-5 to individual jobs so that if two jobs in t he 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 t he 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.