Oracle GoldenGate 12.2

Oracle GoldenGate 12.2 New Feature – GETPARAMINFO

By September 21, 2016 No Comments
GETPARAMINFO
New parameter introduced from Oracle GoldenGate 12.2

This parameter will provide you the information of the parameters which are associated with the active running processes like Manager, Extract and Replicat. 
You can get the information of one single parameter of the running process or information of all the parameters.

SYNTAX

             SEND MGR | group GETPARAMINFO [parameter_name] [FILE output_file]

MGR - Manager process Name

group - Extract or Replicat Group name.

parameter_name - Name of the parameter of which the information is to be displayed.

FILE output_file - The output information can be either displayed in the screen or it can written to a file. To write or redirect the output information to a file use this option.

By default it will display the information of all the parameters used in the Extract, Replicat or Manager processes with respect to the request. Let us see by the examples below,

GGSCI (OGGR2-1.localdomain) 1> SEND EXTRACT INEXT GETPARAMINFO

Sending GETPARAMINFO request to EXTRACT INEXT ...

GLOBALS

checkpointtable : ggadmin.ggschkpt

/ogg/dirprm/inext.prm

extract : inext
userid : ggadmin
password : *******
tranlogoptions : <enabled>
integratedparams : (MAX_SGA_SIZE 100, PARALLELISM 2)
exttrail : /ogg/dirdat/lt
logallsupcols : <enabled>
updaterecordformat : COMPACT
table : veera.*

Default Values

deletelogrecs : <enabled>
fetchoptions :
userowid : <enabled>
usekey : <enabled>
missingrow : ALLOW
usesnapshot : <enabled>
uselatestversion : <enabled>
maxfetchstatements : 100
usediagnostics : <disabled>
detaileddiagnostics : <disabled>
diagnosticsonall : <disabled>
nosuppressduplicates : <enabled>
flushsecs : 1
passthrumessages : <enabled>
ptkcapturecachemgr : <enabled>
ptkcaptureift : <enabled>
ptkcapturenetwork : <enabled>
ptkcapturequeuestats : <enabled>
ptkspstats : <enabled>
tcpsourcetimer : <enabled>
tranlogoptions :
bufsize : 1024000
asynctransprocessing : 300
checkpointretentiontime : 7.000000
failovertargetdestid : 0
getctasdml : <disabled>
minefromsnapshotstby : <disabled>
usenativeobjsupport : <enabled>
warnlongtrans : 3600 second(s)
retrydelay : 60
allocfiles : 500
allowduptargetmap : <disabled>
binarychars : <enabled>
checkpointsecs : 10 second(s)
cmdtrace : OFF
dynamicresolution : <enabled>
eofdelay : 1
eofdelaycsecs : 100
functionstacksize : 200
numfiles : 1000
ptkcapturetablestats : <enabled>
ptkmaxtables : 100
ptktablepollfrequency : 1
varwidthnchar : <disabled>
enableheartbeat : <enabled>
ptkcaptureprocstats : <enabled>
ptkmonitorfrequency : 1
use_traildefs : <enabled>
.

To get the information of a particular parameter of an Active running Extract process INEXT,

GGSCI (OGGR2-1.localdomain) 2> SEND EXTRACT INEXT GETPARAMINFO TRANLOGOPTIONS

Sending GETPARAMINFO request to EXTRACT INEXT ...

/ogg/dirprm/inext.prm

tranlogoptions : <enabled>
integratedparams : (MAX_SGA_SIZE 100, PARALLELISM 2)

Default Values

tranlogoptions :
bufsize : 1024000
asynctransprocessing : 300
checkpointretentiontime : 7.000000
failovertargetdestid : 0
getctasdml : <disabled>
minefromsnapshotstby : <disabled>
usenativeobjsupport : <enabled>
.

Leave a Reply

© 2020 ORACLE-SCN. All Rights Reserved.

error: Content is protected !!