Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Isolation level: repeatable read vs read stability.

479456Oct 29 2010 — edited Oct 29 2010
I was going through the following link [http://www.developer.com/print.php/3706251] about database isolation levels. There was a statement:

In Read Stability, only rows that are retrieved or modified are locked, whereas in Repeatable Read, all rows that are being referenced are locked.

What is meant by "all rows that are being referenced".

According to my understanding in case of repeatable read, the table is locked. Is this understanding correct?

Edited by: user476453 on Oct 29, 2010 2:03 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2010
Added on Oct 29 2010
1 comment
344 views