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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 27 Jan 2006 02:47:48 GMT
Message-Id: <pan.2006.01.27.02.47.48.442763@sbcglobal.net>


On Thu, 26 Jan 2006 16:04:27 +0000, Chuck wrote:

> Looking at 60,000 block dumps rather than determining
> how long the longest running query runs for,

That is available from V$UNDOSTAT. The trick here is to find to cause, not to fix the problem. Fixing the problem is easy, you got to ask yourself one question: why is this happening?

-- 
http://www.mgogala.com
Received on Thu Jan 26 2006 - 20:47:48 CST

Original text of this message

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