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

xhoster_at_gmail.com wrote:

> In fact, I've seen 1555's disappear merely by changing undo_retention in a
> situation (unlike this one) where it couldn't easily be rewritten as an
> insert into...select and where removing the commit from the loop would have
> been rather inconvenient.
>
> Xho

The potential problem with changing undo retention, to cover for badly designed code, is that increased undo retention is not free. Howard Rogers, dizwell.com, has written about this too.

-- 
Puget Sound Oracle Users Group