Re: -1555-ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small

From: <spremuta_at_gmail.com>
Date: 12 Sep 2006 07:56:22 -0700
Message-ID: <1158072982.795016.299660@p79g2000cwp.googlegroups.com>

Brian Peasland ha scritto:

> > Well, if this script receives ORA-1555 on regular basis, then you
> > should increase undo_retention to cover the longest run time period of
> > this query so that Oracle retains undo needed by it for the whole
> > duration of the process (say, undo_retention=22000.) Or better try to
> > optimize that script so that it takes less time to complete, ideally
> > less than 3 hours.
>
> Additionally, make sure that your UNDO tablespace is sufficiently large
> to hold all of this undo.
>
>
> HTH,
> Brian
>

So i should extend the undo_retention parameter for example to 28800, is correct?
extending undo_retention parameter need stop of oracle instance i guess...right?
this change could cause overload on the db and the server?

then
do i have to change script in the lines: IF CONTATORE_COMMIT = FREQUENZA_COMMIT

 >                  THEN CONTATORE_COMMIT := 1;
 >                  COMMIT;
 >                END IF;

?
deleting only commit line or all that lines in your opinion?

thanks for helping Received on Tue Sep 12 2006 - 09:56:22 CDT