Re: optimal size for rollback

From: Igor Laletin <ilaletin_at_usa.net>
Date: 23 Sep 2002 17:54:13 -0700
Message-ID: <f9226414.0209231654.3954e42e@posting.google.com>

Nuno Souto <nsouto_at_optushome.com.au.nospam> wrote in message news:<3d8f09ac$0$23169$afc38c87_at_news.optusnet.com.au>...
> 23 Sep 2002 00:10:19 -0700, Igor Laletin said (and I quote):
>
> > There is no "more". We're talking about just one particular symptom -
> > an application allows user to start a transaction and go for a lunch.
>
> Or it just starts a very long running query after an update. Or a number
> of mixes thereof.

No "or" :) In this particular branch we didn't discuss long running query, ora-1555, etc. Just transactions which stick around forever.

> > So most of the application you worked with since 1986 do that? Bad
> > luck.
>
> Yup. And that includes even Oracle Applications.

Well... Bad luck :) BTW it was a genuine question, I didn't mean to be sarcastic. And I do share your opinion on the quality of the applications.

Have a great holiday,
Igor Received on Mon Sep 23 2002 - 19:54:13 CDT