Re: Logical Standby Issues (cont.)
- From: "Mark Strickland" <strickland.mark@xxxxxxxxx>
- To: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- Date: Mon, 14 Aug 2006 17:17:06 -0700
I did the test using FORALL in a PL/SQL anonymous block with a commit
every 100,000 rows (so there were ten iterations with a FORALL and
commit in each iteration). It took 23 minutes. A simple cursor FOR
loop with commits every 100,000 rows took 25 minutes while 10 straight
SQL update statements took 23 minutes. Very comparable. A bug has
been filed for my SR, so maybe my next update to this thread will be
news of a planned bug fix. I can dream can't I?
Thanks for the suggestion.
Mark
--
//www.freelists.org/webpage/oracle-l
Other related posts:
