Compress option of OGG

We can’t generate compressed trail files now.
 you can only configure Oracle GoldenGate to compress trail files in its extract pump process and distpath where you can specify COMPRESS in the RMTHOST option. For example,
       RMTHOST localhost, mgrport 7789, compress, compressthreshold 512 
  • COMPRESS
    This option is valid for online or batch Extract processes and any Oracle GoldenGate initial-load method that uses trails. Compresses outgoing blocks of records to reduce bandwidth requirements. Oracle GoldenGate decompresses the data before writing it to the trail. COMPRESS typically results in compression ratios of at least 4:1 and sometimes better. However, compressing data can consume CPU resources.
  • COMPRESSTHRESHOLD
    This option is valid for online or batch Extract processes and any Oracle GoldenGate initial-load method that uses trails. Sets the minimum block size for which compression is to occur. Valid values are from 0 and through 28000. The default is 1,000 bytes.
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters136.htm#GWURF631

| ALTER DISTPATH <path-name>
| ( BEGIN ( NOW
| | SEQNO <sequence-number> RBA <relative-byte-address>
| | <begin-datetime> )
| | TARGET ( URI <target-uri>
| | FORMAT ( CANONICAL | TEXT | SQL | XML )
| | SIZEMB <megabytes-number>
| | SEQLEN <sequence-length>
| | PROXY URI <proxy-uri>
| TYPE ( SOCKS | HTTP )
| [ CSALIAS <credential-store-alias>
| [ CSDOMAIN <credential-store-domain> ] ]
| | ENCRYPTION ALGORITHM <encryption-algorithm>
| | COMPRESSION ( ON | OFF | THRESHOLD <compression-threshold> ) )
| | RULE ( PASSTHRU
| | FILTER [ CHUNKIDS <chunk-ids> ]
| [ OBJECTNAMES <object-names> ]
| [ OBJECTTYPES [ DML ] [ DDL ] [ PROCEDURE ] ]
| [ TAGS <binary-tags> ]
| [ PROCEDUREFEATURENAMES <feature-names> ]
| [ COLUMNVALUES <column-values> ] )
| [ RELATION ( AND | OR ) ]
| [ ACTION ( INCLUDE | EXCLUDE ) ]
| | OPTIONS [ AUTORESTART RETRIES <retries> [ DELAY <delay> ] ]
| [ CRITICAL ( YES | NO ) ]
| [ EOFDELAY <eofdelay> ]
| )

This feature reduces the bandwidth requirements. COMPRESS typically results in compression ratios of at least 4:1 and sometimes better. However, compressing data can consume CPU resources. Oracle GoldenGate (collector) decompresses the data before writing it to the trail. Therefore, you can’t see the compressed trail files.

Leave a Reply

Your email address will not be published. Required fields are marked *