Oracle GoldenGate offers data compression at the network layer, enhancing data transfer rates. Once configured in the Extract or Data Pump process parameter file, the Server Collector process on the target machine automatically decompresses the data before writing to the remote trail files.
Depending on your data, the maximum compression ratio can exceed 5:1, which will help transfer speeds on low bandwidth networks. However, additional CPU utilization is possible when compared to no data compression, which is the default.
If compression is enabled, the following statistics are available in the Extract process report, requested via the
GGSCI SEND command with the