Re: Snapshot too old but UNDO_RETENTION very high

Firehawk® wrote:

> My developers made a UPDATE from ONE table with 9 Million of lines.
> Script read a line, make many consistencies and update same line in another
> column that was empty before.
> Ok, tipical case of ORA 1555, but:
> 1) Oracle 9i
> 2) My undo tablespace has 30 Gb !!!
> 3) undo_management='AUTO'
> 4) undo_retention=489600 (very high, no ?)
> I am with a important production process stopped because this problem
>
> Oracle 9.2.0.4
> AIX 5.2.0.0
>
> Any hint ?

My guess is that they are doing incremental commits.

-- 
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)