Re: Logical Standby Issues (cont.)

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:
> 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).
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: - 10g has dictionary views named *_LOG_GROUPS, *_LOG_GROUP_COLUMNS. - also in 10g you can switch on supplemental logging with finer granularity, i.e. down to the table level.

HTH

• Andrey

--
http://www.freelists.org/webpage/oracle-l