Oracle GoldenGate 12.2

Oracle GoldenGate 12.2 New Feature – INFO PARAM

By September 21, 2016 No Comments
INFO PARAM
New command introduced in Oracle GoldenGate 12.2

Displays the parameter definition. It is similar to the "man" command in the Linux OS. As the man command in Linux displays the Description, options etc, the INFO PARAM command also displays the full information of the parameter which is specified. The child options which are available for this command is listed in the "OPTIONS" tab.

The below are the list of information displayed for the specified parameter in the command,

param name 
description
argument 
default 
options 
component(s) 
mode(s) 
platform(s)
versions 
database(s)
status 
mandatory 
dynamic 
relations

SYNTAX

           INFO PARAM <parameter_name>

If you need the information of the particular option of the parameter, then the command would be as below,

           INFO PARAM <parameter_name>.<option_nanme>

Check the below example,

GGSCI (OGGR2-1.localdomain) 1> INFO PARAM RMTHOST

param name : rmthost
description : Name or IP address of the remote host.
argument : string
default : no default
options : compress, compressthreshold, cpu, encrypt, hometerm, keyname, mgrport
 nostreaming, params, password, port, pri, processname, socksproxy
 streaming, tcpbufsize, tcpflushbytes, timeout, user
component(s): EXTRACT
mode(s) : all Extract modes
platform(s) : all platforms
versions :
 min ver : 10.1.0.1
database(s) : all supported databases (on the supported platforms).
status : current
mandatory : false
dynamic : false
relations : none

To get the information of the particular option available for this parameter RMTHOST, use the below command.,

For example, option - COMPRESS

GGSCI (OGGR2-1.localdomain) 2> INFO PARAM RMTHOST.COMPRESS

param name : rmthost.compress
description : 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.
argument : no argument
options :
component(s): EXTRACT
mode(s) : all Extract modes
platform(s) : all platforms
versions :
 min ver : 10.1.0.1
database(s) : all supported databases (on the supported platforms).
status : current
mandatory : false
dynamic : false
relations : none

 

Leave a Reply

© 2020 ORACLE-SCN. All Rights Reserved.

error: Content is protected !!