13. Understanding the Locking System : User-Controlled Locking--SET LOCKMODE : Isolation Levels : Repeatable Read Isolation Level
 
Share this page                  
Repeatable Read Isolation Level
In Repeatable Read (RR) isolation mode, locks are automatically released from data opened for reading but never read. With RR, if the application returns to the same page and re-reads the row, the data cannot have changed. If a SELECT statement is issued twice in the same transaction, “phantom rows” can occur. RR does not prevent concurrent inserts.