RE: Strange snapshot too old during a select statement

From: Joe Cooper <aregularjoe8_at_yahoo.com>
Date: Thu, 11 Mar 2004 15:54:15 -0800 (PST)
Message-ID: <20040311235415.80488.qmail@web42003.mail.yahoo.com>

Hi, Phillipe!

You're facing the same problem I had with a client about two months ago. May I suggest going to MetaLink and look up the following docs:

40689.1 -- very good overview of the 01555 problem. Possible causes and suggested solutions.

252686.1 -- very specific (and very NEW) doc. You didn't mention O/S or Oracle Version. This brief article deals with Solaris and 9.2.0.<3 and 4>. It sites BUG #3060261.

My experience was that regardless of how high you set the undo retention time (we stopped experimenting at 18 hours, though the query ran in under two before this problem reared its ugly head), the 01555 wouldn't go away. When I researched the bug noted above, it seemed applicable to most O/S, and described a symptom that we were experiencing dead on accurately.

Anyway, I'd like to say that the patch worked, but I really don't know. The company ran out of money to renew my contract before I had the chance to install and test it. (So now I put out fires for another company!)

I wish you the best of luck in solving this problem.

HTH Joe Cooper
Senior Oracle DBA
Sheshunoff Information Services
(a Thomson Media company)

"NGUYEN Philippe (Cetelem)" <philippe.nguyen_at_cetelem.fr> wrote:

Justin, Richard
thank for your answer, I will increase the undo retention time and let you know...

Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster.

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 - 18:05:36 CST