Something else that may be of value when trying to avoid a snapshot too old
error is to tune the query to make sure it is running as efficiently as
possible. Generally the faster the query runs the less chance that data the
query needs to read will be changed and the undo copy of the original data
will be overwritten while the query is running. Depending on how new and
stable the application is, this may be the first thing you should check when
a developer reports a 01555 error.
-- --Original Message-- --
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]On
Behalf Of NGUYEN Philippe (Cetelem)
Sent: Thursday, March 11, 2004 5:10 AM
To: 'oracle-l@(protected) '
Subject: RE: Strange snapshot too old during a select statement
Justin, Richard
thank for your answer, I will increase the undo retention time and let you
know...
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=iso-8859-1 " >
<TITLE >RE: Strange snapshot too old during a select statement </TITLE >
<META content= "MSHTML 6.00.2800.1400 " name=GENERATOR > </HEAD >
<BODY >
<DIV > <SPAN class=119040116-11032004 > <FONT face=Arial color=#0000ff >Something
else that may be of value when trying to avoid a snapshot too old error is to
tune the query to make sure it is running as efficiently as possible.
Generally the faster the query runs the less chance that data the query
needs to read will be changed and the undo copy of the original data will be
overwritten while the query is running. Depending on how new and
stable the application is, this may be the first thing you should check when a
developer reports a 01555 error. </FONT > </SPAN > </DIV >
<DIV > <SPAN class=119040116-11032004 > <FONT face=Arial
color=#0000ff > </FONT > </SPAN > </DIV >
<DIV > <SPAN class=119040116-11032004 > <FONT face=Arial
color=#0000ff > </FONT > </SPAN > </DIV >
<DIV > <FONT face=Tahoma size=2 >-- --Original Message-- -- <BR > <B >From: </B >
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <B >On Behalf
Of </B >NGUYEN Philippe (Cetelem) <BR > <B >Sent: </B > Thursday, March 11, 2004 5:10
AM <BR > <B >To: </B > 'oracle-l@(protected) ' <BR > <B >Subject: </B > RE: Strange
snapshot too old during a select statement <BR > <BR > </FONT > </DIV >
<BLOCKQUOTE dir=ltr style= "MARGIN-RIGHT: 0px " >
<P > <FONT size=2 >Justin, Richard </FONT > <BR > <FONT size=2 >thank for your answer,
I will increase the undo retention time and let you know... </FONT >
</P > </BLOCKQUOTE > </BODY > </HTML >
