Hi,
In case of an oracle RAC setup, A single transaction having 100 DMLs, will all the DML go to the same RAC node? If yes, could you please point me to the official documentation? If no, in what cases does this happen?
I was thinking of below scenarios. Basically my end goal is to understand in a RAC setup for any given transaction is it sufficient to read a particular node's redo log file or will it be distributed across multiple Node in any of the following cases? I do understand it would have node affinity and other configuration to make it work in a single node. But below are few of the scenarios that I can think of where it might have to move transaction to another node?
- Say I start a transaction and perform 10 DMLs for the next 10 days (100 DMLs)and commit the 11th day
- Say I start a transaction on a Node and perform 50 DMLs, then Node becomes highly loaded with other ingress request. Will it perform load balancing move next DMLs of same transaction to another node?
- In case of failure of a Node after say 50 DMLs, will all the DMLs be rolled back on this node and a new Node gets all the 100 DMLs(will the redo log file of the new instance have all the DMLs pertaining to this transaction or it get divided between the 2 nodes redo log files)