Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: optimal size for rollback
"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 ******************************************Received on Mon Sep 23 2002 - 09:08:02 CDT