Re: Mviews Refresh Timings

From: <lyxx09_at_gmail.com>
Date: Mon, 9 Mar 2009 09:10:38 -0700 (PDT)
Message-ID: <27683c97-1723-4c60-b8ef-bebe66cec57e_at_b16g2000yqb.googlegroups.com>

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

This message: [ Message body ]
Next message: Jeremy: "Re: Creating Oracle Text Indexes"
Previous message: Bobby Z.: "Re: Creating Oracle Text Indexes"
Maybe in reply to: lyxx09_at_gmail.com: "Mviews Refresh Timings"
Next in thread: Ind-dba: "Re: Mviews Refresh Timings"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message