Re: select e rollback segment

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 24 Apr 2002 22:07:45 +0100
Message-ID: <3cc836e2$1_2@mk-nntp-1.news.uk.worldonline.com>

"Epicentre Team B Annecy" <carmanet_at_epicentre.fr> wrote in message news:aa6lo5$fmi$1_at_wanadoo.fr...
> I understood that Knut had well answered the question, and I just wanted
to
> suggest
> Renato that, in this case, to increase the rollback segments size was a
> possibility, but
> was not always the good solution. Indeed, if the query plan shows a full
> (large) table
> scan, then the better solution is to execute this query when the database
is
> not too asked
> in rollback segments ressources... But I assume that is not always
possible!
> Are you agree with that?
>
> --
> Celine Armanet
> EPICENTRE
> carmanet_at_epicentre.fr
> Tel. : +33 04 50 09 7000

Well, basically, no, I don't agree. Sorry.

I don't think it's right just to shift a problem into the batch window because the db isn't configured properly (or more likely, the application isn't written properly).

Paul Received on Wed Apr 24 2002 - 16:07:45 CDT