RE: Strange snapshot too old during a select statement
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Mar 2004 11:13:07 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of NGUYEN Philippe (Cetelem)
Sent: Thursday, March 11, 2004 5:10 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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...
Other related posts:
