Re: What does "rollback segment too small" mean?

On 7 Feb 1995, Mike Williams wrote:

> 01555, 00000, "snapshot too old (rollback segment too small)"
> // *Cause: rollback records needed by a reader for consistent read
 are
> // overwritten by other writers
> // *Action: Use larger rollback segments
 

>
> and one extra rollback segment beyond SYSTEM:
>
 

> The error message seems to imply that the rollback segment has reached
> it's max extents, and can grow no bigger. Is that correct? However,
it

Another thing to check is how often your applications are committing transactions. There are some developers who put the commit as the last statement in a very long program and hope that the DBA has sized things huge for them. Received on Wed Feb 15 1995 - 02:28:37 CET