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

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

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

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Tue, 21 Aug 2007 23:26:26 -0600
Message-ID: <KEEDIPJOJLCHPPAIDPDOMEMPEEAA.robertgfreeman@yahoo.com>


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 - 00:26:26 CDT

Original text of this message

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