Re: Snapshot too old but UNDO_RETENTION very high
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 06 Feb 2004 12:47:10 +0100
Message-ID: <3iv620h1satgjk5k5ibaciocufko4mknhi_at_4ax.com>
Date: Fri, 06 Feb 2004 12:47:10 +0100
Message-ID: <3iv620h1satgjk5k5ibaciocufko4mknhi_at_4ax.com>
[Quoted] On Fri, 6 Feb 2004 02:08:33 -0800, "DBA Infopower Support" <support_at_dbainfopower.com> wrote:
> 1) Ask if developers can commit updates (every 500-1000 records for
>example). This should take you through the table update with no 1555s.
> Single update SQL can be changed to PL/SQL block.
Again unprofessional advice. Ora-1555 are being *CAUSED* by
incremental commits.
Opening a TAR is also useless, as Metalink is flooded with articles
how to deal with ora-1555 and it's causes. Oracle is definitely not
going to address this one.
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri Feb 06 2004 - 12:47:10 CET