Hi All,
Please help me understand below scenario:-
Environment:- 2 node rac database
Database:- Oracle 11204
User A is connected to instance 1 and
User B is connected to instance 2
User A updates a row from EMP table and commits the change. The moment he commits, the node crashes.
Now if User B tries to fetch the same row from EMP table, will he be getting the updated value of the row or would he still see the old value.
My understanding is Oracle follows ACID rule and therefore User B should see the consistent image, i.e updated value. But I'm not sure how oracle manage to get that information, specially when node 1 is still down.
Please help me understand this logic.