Data compression

Oracle GoldenGate has supported data compression at the network layer for many years, enhancing data transfer rates. Compression techniques often improve performance, given the reduction in data that needs to be transferred from source to target. When 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.

Compressing the data stream

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 required when compared to no data compression, which is the default.

If compression is enabled, the following statistics are available in the Extract process report, which is obtained via the GGSCI SEND command with the GETTCPSTATS argument:

• The compression CPU time: This specifies the on-CPU time that the process consumed.
• The compress time: This...