|
One problem with too many nodes / instances in RAC is indirectly related to the setting of MAX_COMMIT_PROPAGATION_DELAY. Contrary to Oracle's belief, many applications do require this parameter to be set to 0 to avoid read inconsistency in the application. (By this, I mean when you commit and immediately read the result, you sometimes see a result as if the previous commit was not done. I don't mean any data corruption inside the database.)
This problem is more common than Oracle thought and the only solution is setting that parameter to 0, in spite of Oracle's warning. Why is this related to number of instances of RAC? Because if you have only two instances, setting this parameter to 0 causes no or very little performance overhead. But with more instances, God forbid 128, setting it to 0 causes a very noticeable delay on each commit, no matter how fast cross-instance communication is.
Yong Huang |
|