One reason not to choose logical standby would be if you often perform
massive inserts/updates/deletes in the primary database. I have
verified a performance issue in 10.1.0.3, 10.1.0.5 and 10.2.0.2 where
SQL Apply steadily gets slower and slower while processing a large
number of changes that are part of a single transaction. A workaround
is to do commits every 100,000 rows or so but that would add
complication to your code, no doubt.
Regards,
Mark Strickland
Seattle, WA
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 03 2006 - 12:25:11 CST
