Re: wield ORA-01555 error???

From: kathryn axelrod <kat.axe_at_gmail.com>
Date: Tue, 16 Mar 2010 09:58:57 -0700
Message-ID: <eee76b6f1003160958v298b606ei8e3ac496f8a62c85_at_mail.gmail.com>

Is your undo retention really set to 5.5 hours, or was 20000 a typo?

On Tue, Mar 16, 2010 at 4:48 AM, dba1 mcc <mccdba1_at_yahoo.com> wrote:

> we have ORACLE 10.2.0.4 on UNIX system. Recently one of our databases has
> ORA-0155 error happen several times. this database already setup:
>
> 1. undo_retention = 20000
>
> 2. undo data file size current is 9 GB and can autoextend to 25 GB
>
> how come we still get ORA-01555 error?
>
> Thanks.
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 16 2010 - 11:58:57 CDT