Oracle Database Administration 2019 Certified Professional — Question 15
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)
Answer options
- A. Oracle RAC affinity for partitioned tables routes all database requests for a partition tables to a single Oracle RAC instance leading to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings of the partition tables.
- B. Oracle RAC affinity for partitioned tables routes database requests to Oracle RAC instances in such a way that each instance always gets requests for a disjoint subset of rows in the database, this affinity leads to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings.
- C. Oracle RAC affinity for partitioned tables routes database requests to all available Oracle RAC instances evenly to create a global affinity in such a way that each instance always gets an even number of requests leading to higher Oracle RAC performance by using a higher levels of available global cache to reduce global resource contention.
- D. To enhance the performance of distributed transactions with applications server that provides XA affinity, you can automatically spawn new dedicated database RAC instances to isolate distributed transaction.
- E. To enhance the performance of distributed transactions with applications server that provides XA affinity, you can direct all branches of a distributed transaction to a single instance in the cluster to improve cache locality and reduce internode synchronization and block pings.
Correct answer: B, E
Explanation
Option B is correct because it refers to routing requests to distinct subsets of rows, which improves cache locality and reduces contention. Option E is also correct as it highlights the benefit of directing all distributed transaction branches to a single instance, improving performance. Options A, C, and D do not address the specific benefits of reducing global resource contention in the context of affinity.