1. Reference
  2. Connection Attributes
  3. General Use Connection Attributes
  4. Data Store Attributes
  5. ReplicationParallelism

ReplicationParallelism

This attribute specifies the number of tracks, or the number of transmitter/receiver pairs, used for automatic parallel replication.

Set ReplicationParallelism to a number from 2 to 32. This number indicates the number of transmitter threads on the source database and the number of receiver threads on the target database. However, if you are using single-threaded replication, set ReplicationParallelism to 1, which is the default.

The LogBufParallelism and ReplicationParallelism connection attributes are related. LogBufParallelism specifies the number of strands that are mapped to the threads that are specified by ReplicationParallelism. For example, if LogBufParallelism = 4 and ReplicationParallelism = 4, then one strand is mapped to one thread. If LogBufParallelism = 8 and ReplicationParallelism = 4, then two strands are mapped to one thread.

Thus, if ReplicationParallelism is greater than 1, the LogBufParallelism connection attribute must be equal to or greater than the value of ReplicationParallelism. The ReplicationParallelism connection attribute cannot exceed the value of LogBufParallelism. In order for the number of strands to be equally distributed across the number of threads, you may want to make LogBufParallelism a multiple of the number of threads specified in ReplicationParallelism.

To learn more about automatic parallel replication, see Configuring Parallel Replication in the Oracle TimesTen In-Memory Database Replication Guide.

Required Privilege

Only the instance administrator can change the value of this attribute.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Setting

Set ReplicationParallelism as follows:

Where to set the attribute How the attribute is represented Setting

C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen Classic

ReplicationParallelism

n - A value between 1 and 32, indicating the number of tracks to replicate in parallel. The default is 1.

Windows ODBC Data Source Administrator

Not applicable

Restrictions

When parallel replication is enabled, the Description column of the ttLogHolds built-in procedure displays one row per track per subscriber node.