Re: Oracle + PHP + long process

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Thu, 05 Oct 2006 23:54:16 GMT
Message-Id: <pan.2006.10.05.23.54.15.295359@verizon.net>

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

Received on Thu Oct 05 2006 - 18:54:16 CDT