Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Strange snapshot too old during a select statement

RE: Strange snapshot too old during a select statement

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 11 Mar 2004 11:13:07 -0500
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AA3E@USAHM018.amer.corp.eds.com>


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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of NGUYEN Philippe (Cetelem)
Sent: Thursday, March 11, 2004 5:10 AM
To: 'oracle-l_at_freelists.org'
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...



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

-----------------------------------------------------------------
Received on Thu Mar 11 2004 - 11:49:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US