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: 309
/Oracle
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