Parameters and Variables

Parameters and Defaults at Instance Creation

Under most circumstances, Replication Agent provides the best performance when you create an instance with these default configuration property values:

Parameter	Default
column_compression	true
compress_ltl_syntax	true
lti_batch_mode	true
lti_formatter_count	3
lti_max_buffer_size	5000
lti_update_trunc_point	10000
ltl_batch_size	40000
ltl_origin_time_required	false
ltl_send_only_primary_keys	true
rs_packet_size	2048
structured_tokens	true
use_rssd	true

Parameters Affecting Performance Throughput

These configuration properties can affect performance throughput and may need tuning based on environmental factors, such as hardware resources, primary database schema, and transaction profile:

Parameter	Default
log_read_block_count	64
lr_max_op_queue_size	1000
lr_max_scan_queue_size	1000
lti_max_buffer_size	5000
rasd_object_cache_size	1000

Note: The log_read_block_count parameter is used only for Microsoft SQL Server databases.

Depending on the replication environment and system resources as well as the database schema and transaction profile, the maximum memory configuration can also affect performance throughput. The Replication Agent maximum memory configuration is determined by the RA_JAVA_MAX_MEM environment variable if this variable has been set.

Parameters Affecting Performance Latency

These configuration parameters affect performance latency. However, the defaults for these parameters are prioritized for performance throughput, and adjustments made to these parameters to decrease performance latency may negatively affect performance throughput.

Parameter	Default
dump_batch_timeout	5
scan_sleep_increment	5
scan_sleep_max	60

For information about these configuration parameters, see the Replication Agent Reference Manual.