OraFAQ Forum: Server Administration » ORA-01555: snapshot too old

Home » RDBMS Server » Server Administration » ORA-01555: snapshot too old

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01555: snapshot too old [message #231306]

Mon, 16 April 2007 06:47

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

oracle 9i release 2 on SunOs 5.9

ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small

Could you please tell me why this is happening and also how to avaid such types of error?

extent management is local and segment_space_management is manual.

Thanks,
Shahnaz.

Report message to a moderator

Re: ORA-01555: snapshot too old [message #231308 is a reply to message #231306]

Mon, 16 April 2007 06:50

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"ORA-01555: snapshot too old" is the error that is the most asked, described and explained in any Oracle forum or newsgroup.
So search.

Regards
Michel

Report message to a moderator

Re: ORA-01555: snapshot too old [message #231364 is a reply to message #231306]

Mon, 16 April 2007 14:22

madchaz
Messages: 65
Registered: October 2005

Member

It basically means the session's data got flushed out of the buffer because it had been there long enough for other data to take it's place. It can be caused by a number of things, so yea, do some research.

Report message to a moderator

Re: ORA-01555: snapshot too old [message #231365 is a reply to message #231364]

Mon, 16 April 2007 15:04

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

You can avoid this error by increasing undo_retention time period, ultimately you have to increase the size of undo tablespace.

Regards,
Harshad

Report message to a moderator

Re: ORA-01555: snapshot too old [message #231398 is a reply to message #231365]

Mon, 16 April 2007 23:05

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Thanks all for your nice responses.
But my query is not taking too much time, it is taking atmost 30 minutes. Do you mean that i need to change the value of undo_retention periodically? in that what is the value suitable for this type error?

Thanks,
Shahnaz.

Report message to a moderator