521st questions, 053521
521. You notice that a job in a chain has not completed on a nonconstrained RAC database. Which
These are valid reasons why that might occur?
A. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.
B. The job affinity is to a service and one node in that service is unavailable.
C. The job affinity is to an instance and that instance is unavailable.
D. There is no service affinity.
E. None of the above.
Answer:C
The Scheduler enables you want to specify the database service under which a job shocould be run (service affinity ).This ensures better availability than instance affinity because it guarantees that other nodes can be dynamically assigned to the service if an instance goes down. Instance affinity does not have this capability, so, when an instance goes down, none of the jobs with an affinity to that instance can run until the instance comes back up. figure 28-8 analyze strates a typical example of how services and instances cocould be used.
Figure 28-8 Service Affinity and the schedity
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.