Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)
Using affinity to reduce global resource contention has specific benefits. First, Oracle RAC affinity for partitioned tables routes all database requests for partitioned tables to a single Oracle RAC instance. This leads to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings. Second, Oracle RAC affinity for partitioned tables routes database requests to Oracle RAC instances such 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 due to better cache locality and reduced internode synchronization and block pings.
BE https://docs.oracle.com/en/database/oracle/oracle-database/19/jjucp/connection-affinity.html#GUID-AD235F70-10F6-4DF3-8CE4-91769B828DD3 Starting from Oracle Database Release 18c, UCP supports Oracle RAC Data Affinity. When you enable Data Affinity on the Oracle RAC database, data on the affinitized tables are partitioned in such a way that a particular partition or subset of rows for a table is affinitized to a particular Oracle RAC database instance. The affinity leads to higher performance and scalability for the applications due to improved cache locality and reduced internode synchronization and block pings among the RAC instances
A. Correct: Improves performance by routing partitioned table requests to a single instance, enhancing cache locality and reducing inter-instance synchronization. B. Correct: Optimizes performance by distributing requests for disjoint subsets of data among instances, improving cache usage and reducing inter-instance synchronization. C. Incorrect: Incorrectly suggests evenly distributing requests among instances, which doesn't necessarily reduce global resource contention. D. Incorrect: Focuses on spawning new instances for transaction isolation rather than reducing resource contention through affinity. E. Incorrect: Proposes directing all transaction branches to one instance for cache benefits but overlooks overall resource contention reduction.
A - wrong B - true Starting from Oracle Database Release 18c, UCP supports Oracle RAC Data Affinity. When you enable Data Affinity on the Oracle RAC database, data on the affinitized tables are partitioned in such a way that a particular partition or subset of rows for a table is affinitized to a particular Oracle RAC database instance. The affinity leads to higher performance and scalability for the applications due to improved cache locality and reduced internode synchronization and block pings among the RAC instances. https://docs.oracle.com/en/database/oracle/oracle-database/19/jjucp/connection-affinity.html#GUID-AD235F70-10F6-4DF3-8CE4-91769B828DD3