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
|
Title: Message
- RE: Please help with ORA-01555 Snapshot too old Smith, Ron L.
- RE: Please help with ORA-01555 Snapshot too old DENNIS WILLIAMS
- Re: Please help with ORA-01555 Snapshot too old Daniel Fink
- RE: Please help with ORA-01555 Snapshot too old Smith, Ron L.
- RE: Please help with ORA-01555 Snapshot too old Odland, Brad
- RE: Please help with ORA-01555 Snapshot too old DENNIS WILLIAMS
- RE: Please help with ORA-01555 Snapshot too old Dawtrey, Lindsay L