Tag: programming

How about that gg_heartbeat_history table?

How about that gg_heartbeat_history table?

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? →

No PK with GoldenGate?

No PK with GoldenGate?

When Oracle GoldenGate encounters tables without a primary key (PK) for data replication, it has different approaches depending on the situation: 1. Using Unique Indexes: If a unique index exists on the table, GoldenGate can use those columns to identify rows for updates and deletes. This is the preferred approach as it avoids full table scans on … Continue reading No PK with GoldenGate? →