Re: 'lost updates' for web apps

From: <>
Date: Wed, 8 Apr 2009 06:32:33 -0700 (PDT)
Message-ID: <>

On Apr 7, 4:28 pm, joel garry <> wrote:
> On Apr 7, 1:02 pm, wrote:
> > Could someone please inform me if setting ISOLATION LEVEL to either
> > 'READ COMMITED' or 'SERIALIZABLE' can remedy 'lost updates'problem for
> > web-apps? I am using Oracle 10G. TIA.
> It depends.  Go to and search on those terms.
> You'll learn a lot, but it depends on your web-apps as to whether you
> can even remedy your problem.  In particular,
> addresses the obvious question of whether you mean lost updates or
> something else.  As used there, this would be something outside the
> database, so a group about the database might not be the right place
> to ask, or the answer may be no, it can't remedy the problem.
> Here's a mini-faq about posting on this group:
> jg
> --
> is bogus.

Thanks Joel,

  What do you think/know about using Oracle GUID (instead of timestamp, ORA_SCN, hash, checksum, etc.) as the discriminator? Any drawback? Thanks. Received on Wed Apr 08 2009 - 08:32:33 CDT

Original text of this message