Home » RDBMS Server » Server Administration » snap shoot too old ora 01555
snap shoot too old ora 01555 [message #52484] Thu, 25 July 2002 07:06 Go to next message
Keshav Tripathy
Messages: 30
Registered: November 2001
Member
Can you explain me in which cases Snap Shoot too old.
ora 01555

Thanks and regards.

Keshav

Report message to a moderator

Re: snap shoot too old ora 01555 [message #52489 is a reply to message #52484] Thu, 25 July 2002 07:45 Go to previous messageGo to next message
Radek
Messages: 33
Registered: April 2002
Member
check out your rollback segments. Generally there should one rollback segment per 15 sessions. You are getting this error bevause your rollback are too small or you have unsufficient number of segments.
Radek

Report message to a moderator

Re: snap shoot too old ora 01555 [message #52492 is a reply to message #52484] Thu, 25 July 2002 08:07 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Snapshot too old is the most annoying error you can ever get in Oracle.

1. as Radek said, check your rollback segments
2. If you are doing a HUGE job, see to it that no one else is trying to do anything else in the table you are working on.
3. Increase the commit level. (Yes I said INCREASE, sounds funny but is true).

Good luck.

Report message to a moderator

Previous Topic: Re: Error ORA-12505 : Listener could not resolve SID given in connect descriptor
Next Topic: Installing DBMS_JAVA package.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 13 11:49:11 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.