| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Please help with ORA-01555 Snapshot too old
They are both processing the same data, the same way.
-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
Sent: Tuesday, July 22, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Subject: 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-----
Sent: Tuesday, July 22, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L
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.
Any ideas?
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP Received on Tue Jul 22 2003 - 09:36:19 CDT
 |
 |