Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01555 on source database for materialized view refresh across link
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.comReceived on Thu Jan 26 2006 - 20:47:48 CST