Integrated extract Lag at Chkpt close to 10 sec when there is no activity in the database
Last updated on FEBRUARY 01, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.1 and later
Information in this document applies to any platform.
The issue is seen only on Integrated Extract with Lag at Chkpt close to ~10 sec when there are no transactions in the database for extract to Capture.
A Classic Extract on the same machine would be displaying no lag correctly.
The "Lag at Chkpt" is continually displayed close to 10 sec.
Example: Information gathered at different intervals.
Program Status Group Lag at Chkpt Time Since Chkpt
EXTRACT RUNNING CAPTURE 00:00:09 00:00:04
EXTRACT RUNNING CAPTURE 00:00:10 00:00:02
EXTRACT RUNNING CAPTURE 00:00:08 00:00:04
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms