Re: Troubleshooting ORA-01555 while using AUM

Tech Geek wrote:

> This database is being used by end-users for short transactions 24x7 and
> some adhoc batch jobs, which update/insert new records and also does some
> SELECTS. Mostly, the batch jobs and the daily export job run at time of the
> day, ends up with Ora-1555.
>
> Once again, thanks for your time.
>
> Regards
> TG

Which further supports a presumption that UNDO is too small.

Given the low cost of disk space ... throw another 10-20GB at it and see if that solves the problem. My guess is that it will.

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