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 126.96.36.199.0 to 188.8.131.52.3 [Release 11.2]
Information in this document applies to any platform.
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.
This is behavior is due to changes made when introducing parallel replication.
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