O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data compression

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.

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 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 GETTCPSTATS argument:

  • Compression CPU ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required