Re: Reasons for not considering Logical Standby Databases for Reporting purposes
- From: "Mark Strickland" <strickland.mark@xxxxxxxxx>
- To: anuragdba@xxxxxxxxx
- Date: Fri, 3 Nov 2006 10:25:11 -0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
