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.
Correct answer is C and F.
For C – http://www.dba-oracle.com/job_scheduling/job_classes.htm
For F – http://docs.oracle.com/database/121/ADMIN/schedover.htm#i1106396
F – scheduler window priority can be changed, but most logical answer is B .Because the question doesn’t talk about multiple windows here.
another one is C
CF
BC
I will stick with BC in this case
BC – Overall priority of a job within the system is determined first by the combination of the resource consumer group that the job’s job class is assigned to and the current resource plan, and then by relative priority within the job class.
BC – OK
B
You can also assign relative priorities to the jobs within a job class
http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN12366
D and F seems similar results, So I choose BC for this question!
BC
BC
Controlling Resources by Job Class
You can group jobs that share common characteristics and behavior into larger entities called job classes. You can prioritize among the classes by controlling the resources allocated to each class. Therefore, you can ensure that your critical jobs have priority and enough resources to complete. For example, for a critical project to load a data warehouse, you can combine all the data warehousing jobs into one class and give it priority over other jobs by allocating a high percentage of the available resources to it. You can also assign relative priorities to the jobs within a job class.
Controlling Job Prioritization based on Schedules
You can change job priorities based on a schedule. Because your definition of a critical job can change over time, the Scheduler also enables you to change the priority among your jobs over that time frame. For example, extract, transfer, and load (ETL) jobs used to load a data warehouse may be critical during non-peak hours but not during peak hours. Additionally, jobs that must run during the close of a business quarter may need to take priority over the ETL jobs. In these cases, you can change the priority among the job classes by changing the resources allocated to each class.
B,C are correct for me.