Re: Mviews Refresh Timings
From: Ind-dba <oraclearora_at_googlemail.com>
Date: Wed, 11 Mar 2009 04:25:28 -0700 (PDT)
Message-ID: <710e0f39-ed8d-4416-945f-c7c0dbad407d_at_k36g2000pri.googlegroups.com>
On Mar 9, 9:10 pm, "lyx..._at_gmail.com" <lyx..._at_gmail.com> wrote:
> David - I got these timings from DBA_MVIEW_ANALYSIS table.
>
> It has got column FULLREFRESHTIME and INCREMENTALTIME.
>
> For that approach - it is working for me in 10g. I put "C" and it did
> truncate.
>
> you can also verify by enabeling the trace before dbms_mview.refresh.
>
> it should show truncate table and then insert
>
> Regards,
Date: Wed, 11 Mar 2009 04:25:28 -0700 (PDT)
Message-ID: <710e0f39-ed8d-4416-945f-c7c0dbad407d_at_k36g2000pri.googlegroups.com>
On Mar 9, 9:10 pm, "lyx..._at_gmail.com" <lyx..._at_gmail.com> wrote:
> David - I got these timings from DBA_MVIEW_ANALYSIS table.
>
> It has got column FULLREFRESHTIME and INCREMENTALTIME.
>
> For that approach - it is working for me in 10g. I put "C" and it did
> truncate.
>
> you can also verify by enabeling the trace before dbms_mview.refresh.
>
> it should show truncate table and then insert
>
> Regards,
I feel, Oracle never does "truncate" when doing complete refresh, if it does, what would you see in the table when "complete refresh" is in progress.
- Sachin