We are getting the following error:
ORA-01555: snapshot too old: rollback segment number 36 with name "R36" too small
ORA-02063: preceding line from PROD
The user is doing a SELECT from a View and dumping the results into a flat file. Usually it takes 3 -4 minutes to run. Now a couple of times it ranf ro almost 2 hours and errored out with the above errors. The user is coming from another database into our production database.
Our Rollback segments sizes are fine. I thought ORA-1555 is a read consistency error.
Any ideas? Thanks.
Your rollback segments are not fine. Use the "Search Forums" link at http://www.dbasupport.com/forums/search.php
You will find entries similar to:
Click Here to Expand Forum to Full Width