Chapter 6. Monitoring, Tuning, and Troubleshooting GoldenGate
In this chapter we will cover the following recipes:
Steps to configure a BATCHSQL mode
Splitting the replication load into multiple process groups for optimal performance
Optimizing the network settings for a GoldenGate configuration
Performing a healthcheck of a live GoldenGate configuration
Script to perform a regular scheduled healthcheck of a GoldenGate configuration
Steps to measure throughput of a GoldenGate configuration
Steps to re-instantiate a failed GoldenGate configuration
Steps to implement a Heartbeat mechanism for a GoldenGate replication