RE: Please help with ORA-01555 Snapshot too old

Ron

    I'm guessing that one of the loads receives the ORA-01555 and the other doesn't. Does the load commit occasionally? There are some pretty good papers on Metalink for this error.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: Smith, Ron L. [mailto:rlsmith_at_kmg.com] Sent: Tuesday, July 22, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L Subject: Please help with ORA-01555 Snapshot too old

Help!  

I have a production and a test database, both with 3000mg RBS tablespaces with two datafiles. Both have db_block_buffers set at 1000. The only difference is the production db has 7 rollback segments and the test db has 8. The rollback segments are sized at 50mg each on both databases.  

The problem is, at night when the batch load is running (by itself), the load fails with a ORA-01555. The data is the same on both loads. Nothing else is going on in the database during the load. Received on Tue Jul 22 2003 - 09:12:16 CDT