manual dbms_mv.refresh taking longer than scheduled

From: Nag <naga.challa_at_gmail.com>
Date: Thu, 4 Jun 2009 07:49:27 -0700 (PDT)
Message-ID: <ebd2fb19-436c-4761-8581-1dc589584488_at_n19g2000vba.googlegroups.com>

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 Received on Thu Jun 04 2009 - 09:49:27 CDT