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

On Mon, 23 Jan 2006 14:38:34 -0800, 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.

Dan, that exactly might be the problem. The first 3 sessions are probably doing delayed cleanup. Try executing a full table scan (unless the table is enormous) half an hour before the refresh. Just to entertain me, dump few blocks from the table and see whether those blocks have any lock entries in them. Good news is that the MV refresh at 02:30 finds blocks clean and fresh as a rose, so it proceeds without incident.

-- 
http://www.mgogala.com