RE: wield ORA-01555 error???
From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Tue, 16 Mar 2010 07:57:45 -0400
Message-ID: <SNT130-ds19D9EBDAC74AD191A3A99AA62D0_at_phx.gbl>
I'm assuming you've read up on ora-0155 and what causes it, ie. Other users changing your data while you're need a read consistent image. But also look up delayed block cleanout. It hits us all the time, 9i and 10G.
Date: Tue, 16 Mar 2010 07:57:45 -0400
Message-ID: <SNT130-ds19D9EBDAC74AD191A3A99AA62D0_at_phx.gbl>
I'm assuming you've read up on ora-0155 and what causes it, ie. Other users changing your data while you're need a read consistent image. But also look up delayed block cleanout. It hits us all the time, 9i and 10G.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of dba1 mcc
Sent: Tuesday, March 16, 2010 7:49 AM
To: Oracle-L_at_freelists.org
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:
- undo_retention = 20000
- undo data file size current is 9 GB and can autoextend to 25 GB
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 16 2010 - 06:57:45 CDT