Sharing Tips & Tricks from my Database Experience
Tag: Python
Heartbeat tables are used to monitor the lag throughout the data replication cycle. Automatic heartbeats are sent periodically from each source database into the replication streams. These heartbeat records are inserted or updated into the heartbeat table at the target databases. By comparing the timestamps of these heartbeat records, the current and historical lags in … Continue reading How about that gg_heartbeat_history table?
Most of the time, when GoldenGate extract runs without a hitch, and the GoldenGate monitor displays no anomalies or slowness, we are unaware that a prolonged open transaction is holding a lock in the database, which can result in long pipeline latency. This issue can occasionally arise because an application has not properly cleaned up … Continue reading Check for Long Open Transactions with Python
alexlima.com 