GoldenGate - Integrated Replicat Troubleshooting (Doc ID 2819503.1)

Last updated on APRIL 17, 2023

Applies to:

Purpose

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.

Troubleshooting Steps

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