DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle RAC - I/O performance

Hybrid View

  1. #1
    Join Date
    Oct 2020
    Posts
    1

    Post Oracle RAC - I/O performance

    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?

  2. #2
    Join Date
    Dec 2002
    Posts
    74
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width