| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: MView... Fresh build is much faster than Complete refresh...
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_at_OneNeck.com]
Sent: Wednesday, August 22, 2007 2:39 PM
To: robertgfreeman_at_yahoo.com; 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
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]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.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 22 2007 - 15:50:20 CDT
 |
 |