Row locking
Hi all,
A quick question, when I do a write row lock on two particular record rows (for e.g. update row no. 2 and 3), and before the lock is released, I do another read on another two record rows (for e.g. select row no. 3 and 4), does the read for 4 go as per normal before the lock is released on 3, or will it have to wait for the lock on 3 to be released before the reads for 3 and 4 is being done?
Thanks!
Subject
Views
Written By
Posted
Row locking
2746
October 04, 2011 01:41AM
1277
November 23, 2011 01:55AM
1091
February 12, 2012 09:29PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.