Re: manual dbms_mv.refresh taking longer than scheduled

From: ErikYkema <erik.ykema_at_gmail.com>
Date: Thu, 4 Jun 2009 10:08:05 -0700 (PDT)
Message-ID: <16914c8f-de2f-4576-873a-67df1b421e48_at_b1g2000vbc.googlegroups.com>

On 4 jun, 16:49, 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

Maybe the scheduled one happens at another moment when the load is different?
But I have no idea if that is not the reason... Please also post the refresh script that you use, both manual and through dba_jobs.
Regards, Erik Received on Thu Jun 04 2009 - 12:08:05 CDT