Re: 'lost updates' for web apps
From: <student4lifer_at_gmail.com>
Date: Wed, 8 Apr 2009 06:32:33 -0700 (PDT)
Message-ID: <2e9a9ea4-b5aa-4120-b58e-d479e8d05785_at_s20g2000vbp.googlegroups.com>
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...
Date: Wed, 8 Apr 2009 06:32:33 -0700 (PDT)
Message-ID: <2e9a9ea4-b5aa-4120-b58e-d479e8d05785_at_s20g2000vbp.googlegroups.com>
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. Received on Wed Apr 08 2009 - 08:32:33 CDT