Transaction Isolation Level | Lost Update | Dirty Read | Non-Repeatable Read | Phantom Reads | Shared Locks | Schema Stability Lock | Alternate Reality | Update Conflicts |
Read committed | N | N | Y | Y | Acquired for read, released immediately | N | ||
Read uncommitted | N | Y | Y | Y | Not acquired for read | Acquired | N | |
Repeatable read | N | N | N | Y | Acquired for read, held for duration | N | ||
Serializable | N | N | N | N | Locks range or entire table | N | ||
Snapshot | N | N | N | N | Not acquired for read | Y | Y | |
Read committed snapshot | N | N | Y | Y | Not acquired for read | Y | N |
Wednesday, February 11, 2009
Transaction Isolation Levels
I was trying to think of an easy way to memorise/understand these. What do others think of this approach?
Subscribe to:
Post Comments (Atom)
Comment by Kirk Jackson, on 11-FEB-2009 23:18 ( IP: 203.79.94.106 , user id: )
ReplyDeleteVery nice. Thanks,
Kirk