GoldenGate Performance Tuning: Extract, Pump, and Replicat Optimization
GoldenGate replication has three stages, and each one fails differently under load: Extract can fall behind on redo mining, the Pump/Distribution path can saturate the network, and Replicat can bottleneck applying changes to the target. Tuning the wrong stage wastes time and rarely moves the needle — the first job is always figuring out where the lag actually is. 1. Locate the Bottleneck Before Touching Parameters Every tuning exercise starts with LAG and INFO, not with changing parameters blindly. ...