Re: 'lost updates' for web apps
From: joel garry <joel-garry_at_home.com>
Date: Wed, 8 Apr 2009 11:10:51 -0700 (PDT)
Message-ID: <070ffd23-56f9-4aad-81e9-4c1bdcdc50f3_at_3g2000yqk.googlegroups.com>
On Apr 8, 6:32 am, student4li..._at_gmail.com wrote:
> On Apr 7, 4:28 pm, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
>
>
> > On Apr 7, 1:02 pm, student4li..._at_gmail.com 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 asktom.oracle.com 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,http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3...
> > 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: http://www.dbaoracle.net/readme-cdos.htm
>
> > jg
> > --
> > _at_home.com is bogus.http://www3.signonsandiego.com/stories/2009/apr/07/general-motors-seg...
>
> 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.
Date: Wed, 8 Apr 2009 11:10:51 -0700 (PDT)
Message-ID: <070ffd23-56f9-4aad-81e9-4c1bdcdc50f3_at_3g2000yqk.googlegroups.com>
On Apr 8, 6:32 am, student4li..._at_gmail.com wrote:
> On Apr 7, 4:28 pm, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
>
>
> > On Apr 7, 1:02 pm, student4li..._at_gmail.com 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 asktom.oracle.com 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,http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3...
> > 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: http://www.dbaoracle.net/readme-cdos.htm
>
> > jg
> > --
> > _at_home.com is bogus.http://www3.signonsandiego.com/stories/2009/apr/07/general-motors-seg...
>
> 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.
I don't even understand the question. But a quick google turned up http://feuerthoughts.blogspot.com/2006/02/watch-out-for-sequential-oracle-guids.html
jg
-- _at_home.com is bogus. http://datalossdb.org/oldest_incidents_contestReceived on Wed Apr 08 2009 - 13:10:51 CDT