GoldenGate - Integrated Replicat Troubleshooting
(Doc ID 2819503.1)
Last updated on APRIL 17, 2023
Applies to:Oracle GoldenGate - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Integrated Replicat was first introduced in Oracle GoldenGate version 12.1.2, and at the time was the preferred method for applying replicated data into Oracle Database targets. Integrated Replicat is well suited for OLTP use cases as it provides the ability to automatically calculate transactional data dependencies and auto tune parallelism based on the workload. However, the drawback of Integrated Replicat is its inability to split-up and apply large transactions in parallel. Therefore, as of Oracle GoldenGate version 19c, the best practice for data apply into Oracle databases; especially for mixed workloads consisting of OLTP and batch transactions, is to use Parallel Replicat (For Oracle GoldenGate 19c best practices refer to: https://www.oracle.com/a/tech/docs/maa-goldengate-hub.pdf). Even though the preferred, and best practice, apply mechanism for Oracle GoldenGate 19c and above is Parallel Replicat, many organizations have yet to migrate from Integrated Replicat. In this article we shall present troubleshooting information for when Integrated Replicat presents performance issues.
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