Better option is to check that the rollbacks are setup appropriately
first

-----Original Message-----
From: Gakhar Sunandan
[mailto:oracledba-ezmlmshield-x24237630.[Email address protected]
Sent: 31 March 2008 11:52
To: LazyDBA Discussion
Subject: RE: snapshot too old


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




---------------------------------------------------------------------
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




**************************************************************************
IMPORTANT NOTICE

This e-mail may contain information that is privileged, confidential or
otherwise protected from disclosure. It must not be used by, or its contents
copied or disclosed to persons other than the intended recipient(s).
If you have received this e-mail in error, please notify us immediately at
[Email address protected] and delete this e-mail from your system.
Any liability (in negligence or otherwise) arising from any third party
acting, or refraining from acting, on any information contained in this e-mail
is excluded.
It is the responsibility of the recipient to ensure that this message and its
attachments are virus free. UAP Limited are not responsible for any reliance
placed on the information contained in this e-mail and excludes all liability.
**************************************************************************

Oracle LazyDBA home page