InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Ora-01555: Snapshot Too Old Error? How Can It Be Avoided? |
|
Answer» The ORA-01555: snapshot too OLD error indicates that the query cannot find the snapshot it is LOOKING for in the rollback SEGMENT. Rollback segment is designed to hold data blocks that are being CHANGED. It is required to hold old snapshot until the transaction is committed. However, it holds the data until the space is required for other TRANSACTIONS. The ORA-01555: snapshot too old error indicates that the query cannot find the snapshot it is looking for in the rollback segment. Rollback segment is designed to hold data blocks that are being changed. It is required to hold old snapshot until the transaction is committed. However, it holds the data until the space is required for other transactions. |
|