Re: row locking and inserts

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 25 Mar 2007 23:36:09 -0700
Message-ID: <1174890968.972121.272820@l75g2000hse.googlegroups.com>

On Mar 26, 2:29 am, xhos..._at_gmail.com wrote:
> sybra..._at_hccnet.nl wrote:
> > On 25 Mar 2007 09:40:59 -0700, "pp" <pedro.e.pi..._at_gmail.com> wrote:
>
> > >For correctness, my application requires that access to this subset be
> > >serialized.
>
> > Oracle allows you to set the isolation_level of a transaction to
> > serializible.
>
> No, Oracle lets you set the isolation_level to "serializable". However,
> the scare quotes are necessary, as it is not truly serializable.
>

Hmm... How come it's not "truly serializable"? Afaik, Oracle's implementation of serializable isolation level fully conforms to SQL92 definition and prevents all phenomena that it is required to.

Regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Mon Mar 26 2007 - 01:36:09 CDT