RE: MView... Fresh build is much faster than Complete refresh...
- From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
- To: "Ghassan Salem" <salem.ghassan@xxxxxxxxx>
- Date: Wed, 22 Aug 2007 08:03:46 -0600
Yes, there are mview logs, but they are freshly created when I do this
experiment, and there has been no DML on the base tables when I do it as
well.
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
-----Original Message-----
From: Ghassan Salem [mailto:salem.ghassan@xxxxxxxxx]
Sent: Wednesday, August 22, 2007 1:24 AM
To: robertgfreeman@xxxxxxxxx
Cc: oracle-l
Subject: Re: MView... Fresh build is much faster than Complete refresh...
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@xxxxxxxxx> 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
Other related posts:
