Slow Performance of Integrated Replicat Due to SQLEXEC Usage (Doc ID 2271706.1)

Last updated on JULY 31, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Goal

Customer reported lag with integrated  replicat:

Sending GETLAG request to REPLICAT RPKTRS01 ...

Last record lag 1,788 seconds. <======
Low watermark lag: 1.
High watermark lag: 1.
Low watermark position: 31791896146.
High watermark position: 31791896146.



Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms