Re: Mviews Refresh Timings
Date: Mon, 9 Mar 2009 09:10:38 -0700 (PDT)
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, Received on Mon Mar 09 2009 - 11:10:38 CDT