Integrated extract Lag at Chkpt close to 10 sec when there is no activity in the database (Doc ID 1915810.1)

Last updated on FEBRUARY 01, 2017

Applies to:

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

Goal

 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 

 

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