Home >  Term: repeatable read (RR)
repeatable read (RR)

An isolation level that prevents any row that is read from being changed by other applications until the transaction is completed. For WITH HOLD cursors, this applies to when the rows were actually read. For read-only WITH HOLD cursors, the rows might have actually been read in a prior transaction. RR also prevents any row changed by other applications from being read until the change is committed. A transaction that issues the same query more than once is guaranteed to read exactly the same rows again, disallowing phantom rows from being injected into the result set. See also cursor stability, read stability, uncommitted read, isolation level.

0 0

Creator

  • Peteh
  •  (V.I.P) 14225 points
  • 100% positive feedback
© 2025 CSOFT International, Ltd.