Oracle GoldenGate: Knowledge Document Series Post #2

Posted by Doug Reid on Oracle Blogs See other posts from Oracle Blogs or by Doug Reid
Published on Wed, 30 Nov 2011 13:28:06 -0600 Indexed on 2011/12/01 2:12 UTC
Read the original article Hit count: 282

Filed under:

For our second post in this series the team would like to highlight the knowledge document “How-To: Oracle GoldenGate – Heartbeat Process to Monitor Lag and Performance”. This knowledge document outlines a procedure to reliably measure lag between source and target systems through the use of 'heartbeat' tables.

The basic idea is to have a table on the source system that gets updated at a predetermined interval. In your capture processes you would capture the update from the heartbeat table. Using tokens you would add some additional information to the heartbeat record to be able to tell which extract process was capturing the update. This additional information would be used downstream to calculate the real lag time between the source and target systems for a given extract and by checking the last update time on the heartbeat at the target you could also determine if data has stopped flowing between the source and target. 

Click here to view the document

© Oracle Blogs or respective owner

Related posts about /Oracle