Re: ORA-01555 Snapshot too old, is it simply unavoidable?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 05 Aug 2005 21:52:09 +0200
Message-ID: <dpg7f15no60esubaash29nv345d26cd7s8@4ax.com>

On 5 Aug 2005 12:40:58 -0700, "Ken" <alecleekya_at_yahoo.com.hk> wrote:

>Is ORA-01555 something you cannot get rid at all(most of the
>books/articles I read mentioned only how to REDUCE its occurrence)? If
>yes, what, as programmers, should we do in our code to handle it?

*NOT* commit every <n> rows inside a loop, in 8i

In 9i, just make sure your undo_retention_time has been set high enough.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Aug 05 2005 - 14:52:09 CDT

This message: [ Message body ]
Next message: BCC: "Oracle 8i logfile problem"
Previous message: Ken: "ORA-01555 Snapshot too old, is it simply unavoidable?"
In reply to: Ken: "ORA-01555 Snapshot too old, is it simply unavoidable?"
Next in thread: DA Morgan: "Re: ORA-01555 Snapshot too old, is it simply unavoidable?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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