From oracle-l-bounce@freelists.org Thu Mar 11 11:49:39 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2BHndq03323 for ; Thu, 11 Mar 2004 11:49:39 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2BHnco03318 for ; Thu, 11 Mar 2004 11:49:38 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D41D7396E8A; Thu, 11 Mar 2004 11:25:41 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 11 Mar 2004 11:24:22 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from ahmler2.mail.eds.com (ahmler2.mail.eds.com [192.85.154.72]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0CD1E396BDC for ; Thu, 11 Mar 2004 11:09:01 -0500 (EST) Received: from ahmlir5.mail.eds.com (ahmlir5-2.mail.eds.com [192.85.154.135]) by ahmler2.mail.eds.com (8.12.10/8.12.9) with ESMTP id i2BGE2n0002229 for ; Thu, 11 Mar 2004 11:14:02 -0500 Received: from ahmlir5.mail.eds.com (localhost [127.0.0.1]) by ahmlir5.mail.eds.com (8.12.10/8.12.10) with ESMTP id i2BGDN3f013305 for ; Thu, 11 Mar 2004 11:13:23 -0500 Received: from USAHM101.amer.corp.eds.com (usahm101.exmi01.exch.eds.com [207.37.138.189]) by ahmlir5.mail.eds.com (8.12.10/8.12.10) with ESMTP id i2BGDNxD013300 for ; Thu, 11 Mar 2004 11:13:23 -0500 Received: by USAHM101.amer.corp.eds.com with Internet Mail Service (5.5.2657.72) id ; Thu, 11 Mar 2004 11:13:12 -0500 Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AA3E@USAHM018.amer.corp.eds.com> From: "Powell, Mark D" To: "'oracle-l@freelists.org'" Subject: RE: Strange snapshot too old during a select statement Date: Thu, 11 Mar 2004 11:13:07 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C40783.BD515230" X-archive-position: 501 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C40783.BD515230 Content-Type: text/plain; charset="iso-8859-1" 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of NGUYEN Philippe (Cetelem) Sent: Thursday, March 11, 2004 5:10 AM To: 'oracle-l@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... ------_=_NextPart_001_01C40783.BD515230 Content-Type: text/html; charset="iso-8859-1" RE: Strange snapshot too old during a select statement
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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of NGUYEN Philippe (Cetelem)
Sent: Thursday, March 11, 2004 5:10 AM
To: 'oracle-l@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...

------_=_NextPart_001_01C40783.BD515230-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------