Showing results for 
Search instead for 
Did you mean: 

Ora-- 1555

Former Member
0 Kudos

Hello friends,

I know Ora 1555 error Its "Snap shot too old"

In which case we get this error Could any one explain briefly.



Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello , Im very near to this naswer actually but now it is more clear like from my analysis when ever user access some data that image will be stored in UNDOSEGMENT & if another user is trying to access the same DATA It will show snap shot too old.

Former Member
0 Kudos


this note678112 will help u.



Former Member
0 Kudos

Hi Rahul,

You get the ORA-1555 message when you try to access data that someone else is modifying, and Oracle has lost the information that it needs to construct a read-consistent image of that data to present to you. Since you are using Oracle9i's new UNDO tablespace, the ORA-1555 error is an indication that your UNDO_RETENTION parameter is not large enough. You can monitor this by querying the SSOLDERRCNT (Snap Shot Too Old Error Count) column of V$UNDOSTAT. Increase the UNDO_RETENTION parameter and these errors will go away.

I hope it helps you.



Active Contributor
0 Kudos

this happens when you are doing a big update and transaction is not committed. it will fill a rollback segment and fail.

to avoid this, ask your programmer to put more commits.

also, to help, convert to PSAPUNDO and make it big.