Re: select e rollback segment

On Wed, 24 Apr 2002 18:16:15 +0200, "Epicentre Team B Annecy" <carmanet_at_epicentre.fr> wrote:

>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

There are many causes for ora-1555. One of them is simply bad programming practice: committing every individual update to a table you are selecting from in a loop.
Are you really serious in your suggestion to defer all those programs to outside-office hours? Will that resolve the programming problem caused by lazy and sloppy developers, who are afraid their rollback segments will get too big? Of course not! Your suggestion is very dangerous for the innocent and will not resolve anything.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Apr 24 2002 - 11:39:59 CDT