Re: Yet Another Locking Question

From: Steve Adams <steve_adams_at_acslink.net.au>
Date: 1997/10/13
Message-ID: <3442aedc.1302450624@newsserver.trl.oz.au>#1/1

Hi Ron,

There is a reasonably good white paper on this called "Concurrency Control, Transaction Isolation and Serializability" available at http://technet.oracle.com/archive/library/pdf/16683.pdf.

On the rollback segment question, if this paper does not clear it up for you, read the concepts manual. In short, there is no issue with dirty reads on rollback segments.

Regards, Steve
steve_adams_at_acslink.net.au (remove the underscore)

---

On Sun, 12 Oct 1997 20:34:35 -0400, Ron Frank <ronf_at_atl.mindspring.com> wrote:

>I am would like to know how Oracle implements the ANSI locking
>levels.
>
>[snip]
>
>I am also wondering about roll-back
>segments. If a transaction is reading a row from a roll-back
>segment that another transaction is updating or possible deleting,
>isn't that a dirty read?
Received on Mon Oct 13 1997 - 00:00:00 CDT