Monday 16 January 2012

ORA-01555: snapshot too old: rollback segment number string with name string too small

ORA-01555: snapshot too old: rollback segment number string with name string too small

Cause: rollback records needed by a reader for consistent read are overwritten by other writers

Action: If in Automatic Undo Management mode, increase undo_retention setting. Otherwise, use larger rollback segments

No comments:

Post a Comment