Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: MView... Fresh build is much faster than Complete refresh...

Re: MView... Fresh build is much faster than Complete refresh...

From: Ghassan Salem <salem.ghassan_at_gmail.com>
Date: Wed, 22 Aug 2007 09:23:44 +0200
Message-ID: <411d50f60708220023n441692edv45eac62b7d7dace@mail.gmail.com>


Robert,
do you have MV logs on the base tables?, the are cleaned up upon refresh, so if they are 'big', it may explain the result, also, how many indexes do you have on this MView?

rgds

On 8/22/07, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:
>
> So I have this materialized view. When I execute the create materialized
> view command, it takes 32.39 seconds to build. A complete refresh (exec
> dbms_mview.refresh('mview_name','C'); ) from the prompt this takes almost
> 3-4 times longer. Does anyone have any thoughts on why this might be so just
> right off hand. I've not run a 10046 on it yet, but I thought maybe there
> is something about MVIEW Full Refreshes that I'm just missing.
>
> RF
>
>
> Robert G. Freeman
> Oracle Consultant/DBA/Author
> Principal Engineer/Team Manager
> The Church of Jesus Christ of Latter-Day Saints
> Father of Five, Husband of One,
> Author of various geeky computer titles
> from Osborne/McGraw Hill (Oracle Press)
> Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com
> !
> BLOG: http://robertgfreeman.blogspot.com/
> Sig V1.2
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 22 2007 - 02:23:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US