Cursor stability
•SET TRANACTION ISOLATION LEVEL READ COMMMITTED
–Set read locks but release them after the read has happened
•e.g. when cursor moves onto another element during scan
of the results of a
multirow query
–i.e. do not hold R-locks till txn commits/aborts
–Data is not dirty, but it can be inconsistent (between reads of different items, or even between one read and a
later one of the same item)
•Especially, weird things happen between different rows returned by a cursor
Most common in practice!
