Simple solution :: change the commit point by changing checkpoint
frequency.

Regards,
SUNANDAN GAKHAR



-----Original Message-----
From: K Sivakumar
[mailto:oracledba-ezmlmshield-x98700119.[Email address protected]
Sent: Monday, March 31, 2008 4:15 PM
To: LazyDBA Discussion
Subject: snapshot too old


Dear DBA,

Would you tell me what snapshot too old error. When does it
happen? What are the possible causes? How to fix it?

ORA-01555: snapshot too old: rollback segment number 11 with
name _SYSSMU11$ too small

Thank you very much.






Regards,

Sivakumar.K

IT | Capgemini | Chennai

Ph : 044 39839366 | Extn : 39366

Join the Collaborative Business Experience at www.capgemini.com
<http://www.capgemini.com>





This message contains information that may be privileged or confidential
and is the property of the Capgemini Group. It is intended only for the
person to whom it is addressed. If you are not the intended recipient,
you are not authorized to read, print, retain, copy, disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all
copies of this message.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page