RE: MView... Fresh build is much faster than Complete refresh...
- From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Aug 2007 14:50:20 -0600
You are correct, I should have said FALSE, not TRUE.
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: Allen, Brandon [mailto:Brandon.Allen@xxxxxxxxxxx]
Sent: Wednesday, August 22, 2007 2:39 PM
To: robertgfreeman@xxxxxxxxx; oracle-l
Subject: RE: MView... Fresh build is much faster than Complete refresh...
Do you have false and true backwards in your email below?
According to the 10.2 docs, several Metalink notes, and the notes from
Jared and Gints, the default is atomic_refresh=>TRUE, and you have to change
it to FALSE to get the faster TRUNCATE & Direct INSERT behavior.
Regards,
Brandon
----------------------------------------------------------------------------
--
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Robert Freeman
What was interesting too was if I did atomic_refesh=>FALSE (the default)
it took 25 seconds LONGER than if I didn't put it in at all. That was
weird!! Perhaps something with the code tree that is inefficient??
Atomic_refresh=>true = much faster!!!
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Robert Freeman
Thanks everyone, by the way, for all the feedback!! How I missed MVIEW
Refreshes changing from Truncate to delete/insert in 10g I'll never know!!!
The atomic refresh took the refresh down to 51 seconds pretty reliably.
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions
and other information in this message that do not relate to the official
business of this company shall be understood as neither given nor endorsed
by it.
Other related posts:
