Just noticed that my short answer did not pass some "quoting" test (it
had 81% of quoted material, and the limit is 80%).
Repeating...
Mark Strickland:
What are your settings for SUPPLEMENTAL LOGGING for this table/tablespace/database? If your troubles are not due to some bug, then you, probably, are not supplying enough info. Just to remind:I'm running a test in a test environment now because I suspect that Oracle is taking that one update statement and converting it into a separate update statement for each row and each of those updates is doing a full table scan (yes, all the tables that are being maintained by SQL Apply have primary/unique keys).
HTH
-- Andrey
-- //www.freelists.org/webpage/oracle-l