| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Snapshot Refresh Process ??
At times it is faster to do a complete refresh of an oracle snapshot rather than an incremental (fast). My question is how do you know when to do the complete? For example, there are times when a user will run a conversion and they may update 10% of the rows in the master table. If I do a fast refresh it may take 4 hours but if I did a complete it takes 2 hours. I have not seen a pattern in determing the breakeven point. For example, one table we may update 20% of the rows and the incremental is faster other times we update 5% of the rows in a different table and the complete would have been an better option. (Don't quote me on the percentages, just trying to make a point) I remember seeing a reference to this issue that it was addressed at ioug conference years ago, but I did not find anything there. So again the question: What factor(s) should be considered to determine which process(fast or complete) will provide for a faster refresh for higher than normal updates to a master table? Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: Tracy.Rahmlow_at_aexp.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Sep 10 2001 - 22:12:49 CDT
 |
 |