Oh, also, the Applier process was driving one CPU to 100% (4-cpu box).
Only one Applier process was used. Interestingly, when I tested with
10 batches of 100,000 rows each, two Applier processes were used.
Don't know why. I guess that as Log Miner worked its way through the
archived logs, each time that it got through one batch and started
another one, there were probably two streams available for SQL Apply
to work on. Guessing...
Mark
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 10 2006 - 17:49:04 CDT
