Re: Snapshot too old but UNDO_RETENTION very high
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 6 Feb 2004 12:06:39 -0000
Message-ID: <4023834f$0$10344$ed9e5944_at_reading.news.pipex.net>
Date: Fri, 6 Feb 2004 12:06:39 -0000
Message-ID: <4023834f$0$10344$ed9e5944_at_reading.news.pipex.net>
"Firehawk®" <firehawk-brazil_at_gmx.net> wrote in message
news:Xns9486A07016DBEfirehawkcom_at_130.133.1.17...
> My developers made a UPDATE from ONE table with 9 Million of lines.
> Script read a line, make many consistencies and update same line in
another
> column that was empty before.
> Ok, tipical case of ORA 1555, but:
> 1) Oracle 9i
> 2) My undo tablespace has 30 Gb !!!
> 3) undo_management='AUTO'
> 4) undo_retention=489600 (very high, no ?)
> I am with a important production process stopped because this problem
show us the sql
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Fri Feb 06 2004 - 13:06:39 CET