End-to-End Tuning

It may be beneficial in some situations to sacrifice optimal Replication Agent performance to achieve better Replication Server performance and better end-to-end performance through the entire replication system.

For example, in an Oracle-to-ASE replication system using High Volume Adaptive Replication (HVAR), better end-to-end replication performance may be achieved using the same Replication Agent configuration that is used for autocorrection. When a table is configured for autocorrection replication, the column_compression and ltl_send_only_primary_keys parameters are ignored for the table, and the primary Oracle database is configured to log all columns. This decreases Replication Agent performance but may improve the overall performance of the replication system.