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

Daniel Fink wrote:
> Sybrand,
>
> The undo_retention is set to 7200 and the amount of undo being used in
> dbA is less than 50% of the storage capacity of the undo tablespace. My
> instincts/experience tells me that if undo_retention and/or space were
> the issue, the error would be more random (and probably seen more
> often).
>
> I'm still chasing app support to provide more details on what the
> application is doing, and I hope that information offers a clue. In the
> meantime, I'm trying to brainstorm to think about everything I can
> check/test when I can actually get my hands on the system.
>
> Regards,
> Dan
>

Size of the undo_ts in this case is irrelevant if as you say it never gets > 50% full.

If your undo_ts is large enough to hold 2x undo_retention at peak undo rate, the TS will never get > 50% used. If you are getting ora-1555 it is probably because undo_retention is set too low.

How long have the queries on dbA been running when they fail? Probably longer than undo_retention.

-- 
To reply by email remove "_nospam"