Re: wield ORA-01555 error???

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Tue, 16 Mar 2010 11:40:40 -0700 (PDT)
Message-ID: <364724.47924.qm_at_web65415.mail.ac4.yahoo.com>


Please read here:

http://oratips-ddf.blogspot.com/2008/02/dreaded-ora-01555.html
 
David Fitzjarrell





________________________________
From: dba1 mcc <mccdba1_at_yahoo.com>
To: Oracle-L_at_freelists.org
Sent: Tue, March 16, 2010 7:48:49 AM
Subject: wield ORA-01555 error???

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 - 13:40:40 CDT

Original text of this message