I have a question regarding Oracle RAC Cache Fusion - Write/Write Contention.
I would like to know the concept in Write/Write Contention. For example in 3 node cluster A,B,C when node A is updating a block in its cache and after few mins the node B requests for the same block that is already cached in node A. As per the Cahe fusion technology in this case the node A creates the PI image and sends the block to node B. But here i would like to know what happens if node A has not commited the changes it made.
Your mistake is that for write-write A will not construct a PI, but will send the current block. This current image will of course have the uncommitted changes, and the necessary row lock ITL information.
Thank you for your reply. I am still confused with the concept.
The Node A send the current block to the instance that sends requests and node A also preserve the PI of the block sent to the node B.So here after sending the block to node B, if node A commits the changes it made, how the changes will be recorded in the block.