Re: Snapshot too old but UNDO_RETENTION very high

DBA Infopower Support wrote:

> Hello Sybrand,
>
> I believe we disagreed on very different issues:
>
> In case you are discussing (lengthy selects for example) , high
> transaction activity from other sessions would definitely cause ora-1555 at
> some point
>
> In a case, that user describes, looks like lengthy update is failing. My
> recommendation is to break one big update into small batched updates using
> PL/SQL (or any other language - Perl, fro example). This will greatly reduce
> probability of 1555 on an update itself.
>
> Overall, let user decide which advice helps to resolve the problem and
> not to flame each other.
>
> Regards,
> Support
>
> DBA Infopower

We've seen your recommendation. It is not a good one and the OP would be ill-advised to follow it.

Even though your advice was bad you seem to be genuinely trying to help people so can we get you to show us the courtesy of posting with your real name instead of immitating a spammer?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)