Home » RDBMS Server » Server Administration » ORA-01555: snapshot too old
ORA-01555: snapshot too old [message #231306] Mon, 16 April 2007 06:47 Go to next message
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.
Re: ORA-01555: snapshot too old [message #231308 is a reply to message #231306] Mon, 16 April 2007 06:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-01555: snapshot too old [message #231364 is a reply to message #231306] Mon, 16 April 2007 14:22 Go to previous messageGo to next message
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.
Re: ORA-01555: snapshot too old [message #231365 is a reply to message #231364] Mon, 16 April 2007 15:04 Go to previous messageGo to next message
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
Re: ORA-01555: snapshot too old [message #231398 is a reply to message #231365] Mon, 16 April 2007 23:05 Go to previous messageGo to next message
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.
Re: ORA-01555: snapshot too old [message #231402 is a reply to message #231306] Mon, 16 April 2007 23:31 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Please post via CUT & PASTE exactly what is being run which has been hit with ORA-01555.
Re: ORA-01555: snapshot too old [message #231405 is a reply to message #231398] Mon, 16 April 2007 23:39 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
As already asked by "anacedent" please post
show parameter undo 


regards
Taj
Previous Topic: could not acess to oracle web administration interface
Next Topic: Directories
Goto Forum:
  


Current Time: Thu Dec 08 12:21:29 CST 2016

Total time taken to generate the page: 0.10028 seconds