Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: optimal size for rollback

Re: optimal size for rollback

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 23 Sep 2002 15:08:02 +0100
Message-ID: <3d8f2043$0$1289$ed9e5944@reading.news.pipex.net>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US