Posted by Mladen Gogala on 10/05/06 23:54

On Thu, 05 Oct 2006 15:07:11 +0100, Andy Hassall wrote:

> Sounds like a reasonable approach to me; I was thinking of DBMS_JOB whilst
> reading this, but since you're on 10g then DBMS_SCHEDULER is better. You may be
> able to monitor the progress of the refresh through v$session_longops - I don't
> remember whether mview refreshes show up in there, though - not all operations
> do.

I second that. DBMS_SCHEDULER is the way to go. Unfortunately,
materialized view refreshes do not show as longops.

--
http://www.mladen-gogala.com

[Back to original message]