Re: manual dbms_mv.refresh taking longer than scheduled

From: <johnbhurley_at_sbcglobal.net>
Date: Thu, 4 Jun 2009 10:56:21 -0700 (PDT)
Message-ID: <aeb78c69-b0e4-4434-9221-c30121abf4c4_at_e20g2000vbc.googlegroups.com>

On Jun 4, 10:49 am, Nag <naga.cha..._at_gmail.com> wrote:
> All,
> Our manual refresh taking much longer than scheduled refresh through
> dba_jobs.
> Why is this behaviour? We are using 10gR2 with RAC with three nodes.
>
> We cannot use fast refresh because, our DBA don't want to turn on the
> logs and we have the following in our queries:
> - start with connect by clause
> - union all
> - select with sub query
> - not exist
>
> Any ideas how to make manual refresh fast.
>
> We have materialized defined with the following:
> create materialized view temp_data
> NOLOGGING
>     REFRESH FORCE START WITH sysdate next sysdate + 30/86400
>     AS
>     WITH
> ............................
>
> Your input will be appreciated.
>
> Thanks,
> Naga

Have you considered working with your dba to solve this problem? Received on Thu Jun 04 2009 - 12:56:21 CDT