Re: manual dbms_mv.refresh taking longer than scheduled

From: <naga.challa_at_gmail.com>
Date: Thu, 4 Jun 2009 10:24:31 -0700 (PDT)
Message-ID: <e0687f57-6ce0-490f-a3dd-16de4b40e1b5_at_e24g2000vbe.googlegroups.com>

On Jun 4, 1:08 pm, ErikYkema <erik.yk..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

manual refresh:
exec dbms_mview.refresh('temp_data');

through dba_jobs as follows:
dbms_refresh.refresh("owner"."temp_data");

Thanks,
Naga Received on Thu Jun 04 2009 - 12:24:31 CDT