Re: optimal size for rollback

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 23 Sep 2002 15:51:56 GMT
Message-ID: <3D8F3892.EEB88DC1@exesolutions.com>

Niall Litchfield wrote:

> "Igor Laletin" <ilaletin_at_usa.net> wrote in message
> news:f9226414.0209222310.54d00258_at_posting.google.com...
> > Nuno Souto <nsouto_at_optushome.com.au.nospam> wrote in message
> news:<3d8dc82d$0$22173$afc38c87_at_news.optusnet.com.au>...
> > > 22 Sep 2002 04:23:35 -0700, Igor Laletin said (and I quote):
> > >
> > > PMFJI
> > >
> > > >
> > > > I absolutely agree with you. Just such applications are rare. They may
> > > > exist in a training course but don't survive in production environment
> > > > for long.
> > >
> > > I'm going away on holidays soon, so I can't go into this like it
> > > deserves. Let me just say this: after using Oracle since 1986, I have
> > > yet to see out there a "properly designed" application that doesn't
> > > exhibit one or more of the symptoms Howard and Karen talk about.
> >
> > 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.
> >
> > So most of the application you worked with since 1986 do that? Bad
> > luck.

>

> Every application I have ever worked with allows this. Further more (though
> it is a disaster from the RDBMS management point of view) applications
> *should* allow this. Suppose the CEO is in the middle of inputting his
> expenses for the last month. The phone goes, its the press asking for a
> comment on a story about his mismanagement that the main evening news is
> about to run. He says 'I can give you a quote but I've just got to finish
> this expenses form - the systems we run give me the option of abandoning
> half an hours work or keeping at it for the next half hour - I'll call you
> when I'm done.'.

>

> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer

>
> ******************************************

The solution to this is separate profiles for different classes of users. Anyone that has power over hiring, firing, and budgets usually gets whatever they want.

Of course after being apparised of the risks and agreeing to accept them.

Daniel Morgan Received on Mon Sep 23 2002 - 10:51:56 CDT