Re: Problem with rollback segments - HELP ??

I am getting the 'ORA-01555: snapshot too old: rollback segment # with name "MPS_RS#" too small'

The problem occurs whilst transfering data from the load table to the live table. Specifically it occurs only on the migration machine not the development or live machine (which use same PL/SQL code, why does it not occur there), and it only occurs for the same procedure. The environment is Oracle 7.3.4.3 on Solaris 2.6

The rollbacks have been created with an optimal size setting. Is it shrinking back to this, thereby loosing the segment data whilst waiting for a long query?

We have tried to increase the PCTINCREASE on the rollback segment but this has no effect.

Any suggestions for tracing the cause of why this problem occurs, and perhaps why not on the other machines?

Thanks

Haroon Received on Wed Jul 07 1999 - 03:05:59 CDT