snapshot too old

I have a pro*c program that is used to update selected records in a large table. After processing about 400,000 records the program aborts with the ORA-01555 error. The program declares a cursor for the select statement and then fetches 500 rows at a time using the cursor. It then has the possibility of updating any or all of the rows depending on the values of the columns selected. A commit is done after the update and another 500 rows is fetched. This will continue until the error occurs.

I know that the rollback segments hold the read consistent view of the data being used by the cursor and the updated data for rollback purposes. The database has four rollback segments configured.

Is the problem not enough rollback segments? I did not see any new extents allocated when watching the rollback activity with monitor.

Any information on this would be appreciated.

Thanks in advance.

Dan Received on Wed Mar 22 1995 - 22:58:04 CET