Oracle GoldenGate: Knowledge Document Series Post #2
- by Doug Reid
0
false
18 pt
18 pt
0
0
false
false
false
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;}
0
false
18 pt
18 pt
0
0
false
false
false
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;}
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