1. Microservices Architecture Documentation
  2. Performance
  3. Monitor
  4. Monitor Lag
  5. Monitor Lag Using Automatic Heartbeat Tables
  6. Using the Automatic Heartbeat Commands

Using the Automatic Heartbeat Commands

You can use the heartbeat table commands to control the Oracle GoldenGate automatic heartbeat functionality as follows.

Command Description

ADD HEARTBEATTABLE

Creates the heartbeat tables required for automatic heartbeat functionality including the LOGBSN columns.

ALTER HEARTBEATTABLE

Alters existing heartbeat objects.

ALTER HEARTBEATTABLE UPGRADE

Alters the heartbeat tables to add the LOGBSN columns to the heartbeat tables. This is optional.

DELETE HEARTBEATTABLE

Deletes existing heartbeat objects.

DELETE HEARTBEATENTRY

Deletes entries in the heartbeat table.

INFO HEARTBEATTABLE

Displays heartbeat table information.