My Oracle Support Banner

Parallel Replication performance is slower in comparison to 7.x when transaction size is big (Doc ID 1549702.1)

Last updated on AUGUST 23, 2021

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.2.0 to 11.2.2.4.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The performance of a replication using primary-primary replication and inserting 10 million rows has declined drastically in version TT 11.2.2.x compared to earlier versions.

Here is one test result showing the difference

Here Total elapsed time means Time to insert rows in Primary node and replicate those to subscriber node + time taken for replication bookmark in subscriber side to sync

This does not happen when the transaction size is smaller ( 10k - 1million Records ). Only when the number of record inserted in primary side is very large (10 million) does it happen.

Changes

 This is behavior is due to changes made when introducing parallel replication.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.