Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)
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.
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
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
217972f
5 months agoTest_1
6 months, 3 weeks agolcoleandro
6 months, 3 weeks agokrwi1
10 months, 2 weeks ago