In RAC environment since we are using more than one nodes for a database, will there be more read/write congestion than in a standalone ASM database?
Printable View
In RAC environment since we are using more than one nodes for a database, will there be more read/write congestion than in a standalone ASM database?
Like anything else, the answer is - it depends. Oracle does a pretty good job running the query on same node so cache can be reused. But if due to load balancing or other load, if same data set is needed in second node, it will transfer the cache over interconnect. This is still better than reading disk but not same as reading local cache.
So the goal is to minimize interconnect traffic. One way is to distribute distinct load to different nodes so there is less data sharing. There are v$views you can query to get stats on cache read, interconnect data move.