ReplicationApplyOrdering

ReplicationApplyOrdering enables parallel replication.

When used with the ReplicationParallelism attribute, multiple transmitters on the master send to multiple receivers on the subscriber.

• Automatic parallel replication: Parallel replication over multiple threads that automatically enforces transactional dependencies and all changes applied in commit order. This is the default.

• Automatic parallel replication with disabled commit dependencies: Parallel replication over multiple threads that automatically enforces transactional dependencies, but does not enforce transactions committed in the same order on the subscriber database as on the active database. You can also increase replication throughput by applying transactions to specific tracks.

For more details on configuring parallel replication, see Configuring Parallel Replication in Oracle TimesTen In-Memory Database Replication Guide.

This attribute also sets parallel propagation for AWT cache groups. By default, this attribute enables parallel propagation of updates to the Oracle database. To learn more about parallel AWT caching, see Improving AWT Throughput with Parallel Propagation to the Oracle Database in Oracle TimesTen In-Memory Database Cache 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 ReplicationApplyOrdering 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	ReplicationApplyOrdering	0 - Specifies automatic parallel replication. Automatic parallel replication is available for both classic and active standby pair replication schemes. (default) 2 - Specifies automatic parallel replication with disabled commit dependencies.
Windows ODBC Data Source Administrator	Not applicable

Restrictions

Restrictions when using automatic parallel replication with disabled commit dependencies:

• The replication scheme must be an active standby pair that uses asynchronous replication. Classic replication schemes are not supported.

• The replication scheme cannot contain cache groups.

• This is only supported for TimesTen Release 11.2.2.8 and greater for both the active and standby masters. Both the active and standby masters must have commit dependencies disabled.

• XLA is not supported.

All data stores in the replication scheme must use the same setting.