Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01555 on source database for materialized view refresh across link

Re: ORA-01555 on source database for materialized view refresh across link

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 24 Jan 2006 09:44:44 -0800
Message-ID: <1138124682.646198@jetspin.drizzle.com>


Daniel Fink wrote:
> In the 3 hours leading up to the latest occurrence, there were only
> 1800 transactions total, using less than 600 undo blocks, no
> stealing/release/reuse of undo blocks (both expired and unexpired). It
> is a time of almost no activity (when compared to normal daily
> processing).
>
> This is what makes the error so odd.
>
> Regards,
> Daniel Fink

As there is no possible harm in it increase the undo retention and see what happens.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Jan 24 2006 - 11:44:44 CST

Original text of this message

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