Re: Logical Standby Issues (cont.)

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
--
http://www.freelists.org/webpage/oracle-l


Other related posts: