2 Oracle GoldenGate Parameters

This chapter contains summaries of the Oracle GoldenGate parameters that control processing, followed by detailed descriptions of each parameter in alphabetical order.

For instructions on creating, changing, and storing Oracle GoldenGate parameter files, see Administering Oracle GoldenGate for Windows and UNIX.

• Summary of Oracle GoldenGate Parameters
  
• ABORTDISCARDRECS
  
• ALLOCFILES
  
• ALLOWDUPTARGETMAP | NOALLOWDUPTARGETMAP
  
• ALLOWINVISIBLEINDEXKEYS
  
• ALLOWNULLABLEKEYS | NOALLOWNULLABLEKEYS
  
• ALLOWNONVALIDATEDKEYS
  
• ALLOWNOOPUPDATES | NOALLOWNOOPUPDATES
  
• ALLOWOUTPUTDIR
  
• APPLYNOOPUPDATES | NOAPPLYNOOPUPDATES
  
• APPLY_PARALLELISM | MAX_APPLY_PARALLELISM | MIN_APPLY_PARALLELISM
  
• ASCIITOEBCDIC
  
• ASSUMETARGETDEFS
  
• BATCHSQL
  
• BEGIN
  
• BLOBMEMORY
  
• BR
  
• BULKLOAD
  
• CACHEMGR
  
• CATALOGEXCLUDE
  
• CHARMAP
  
• CHECKPARAMS
  
• CHECKPOINTSECS
  
• CHECKPOINTTABLE
  
• CHUNK_SIZE
  
• CMDTRACE
  
• COLCHARSET
  
• COLMATCH
  
• COMPRESSDELETES | NOCOMPRESSDELETES
  
• COMPRESSUPDATES | NOCOMPRESSUPDATES
  
• COMMIT_SERIALIZATION
  
• COORDSTATINTERVAL
  
• COORDTIMER
  
• CREDENTIALSTORELOCATION
  
• CRYPTOENGINE
  
• CUSEREXIT
  
• DBOPTIONS
  
• DDL
  
• DDLERROR
  
• DDLOPTIONS
  
• DDLSUBST
  
• DDLRULEHINT
  
• DDLTABLE
  
• DECRYPTTRAIL
  
• DEFERAPPLYINTERVAL
  
• DEFSFILE
  
• DISCARDFILE | NODISCARDFILE
  
• DISCARDROLLOVER
  
• DYNAMICRESOLUTION | NODYNAMICRESOLUTION
  
• EBCDICTOASCII
  
• ENABLEMONITORING
  
• ENABLE_HEARTBEAT_TABLE | DISABLE_HEARTBEAT_TABLE
  
• ENCRYPTTRAIL | NOENCRYPTTRAIL
  
• END
  
• EOFDELAY | EOFDELAYCSECS
  
• EXCLUDEHIDDENCOLUMNS
  
• EXCLUDETAG
  
• EXCLUDEWILDCARDOBJECTSONLY
  
• EXTFILE
  
• EXTRACT
  
• EXTTRAIL
  
• FETCHOPTIONS
  
• FETCHUSERID
  
• FETCHUSERIDALIAS
  
• FILTERDUPS | NOFILTERDUPS
  
• FLUSHSECS | FLUSHCSECS
  
• FUNCTIONSTACKSIZE
  
• GETAPPLOPS | IGNOREAPPLOPS
  
• GETDELETES | IGNOREDELETES
  
• GETINSERTS | IGNOREINSERTS
  
• GETREPLICATES | IGNOREREPLICATES
  
• GETTRUNCATES | IGNORETRUNCATES
  
• GETUPDATEAFTERS | IGNOREUPDATEAFTERS
  
• GETUPDATEBEFORES | IGNOREUPDATEBEFORES
  
• GETUPDATES | IGNOREUPDATES
  
• GGSCHEMA
  
• GROUPTRANSOPS
  
• HANDLECOLLISIONS | NOHANDLECOLLISIONS
  
• HANDLETPKUPDATE
  
• HAVEUDTWITHNCHAR
  
• HEARTBEATTABLE
  
• INCLUDE
  
• INSERTALLRECORDS
  
• INSERTAPPEND | NOINSERTAPPEND
  
• INSERTDELETES | NOINSERTDELETES
  
• INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
  
• INSERTUPDATES | NOINSERTUPDATES
  
• LIST | NOLIST
  
• LOBMEMORY
  
• LOGALLSUPCOLS
  
• LOOK_AHEAD_TRANSACTIONS
  
• MACRO
  
• MACROCHAR
  
• MAP for Extract
  
• MAP
  
• MAPALLCOLUMNS| NOMAPALLCOLUMNS
  
• MAP_PARALLELISM
  
• MAPEXCLUDE
  
• MAPINVISIBLECOLUMNS | NOMAPINVISIBLECOLUMNS
  
• MARKERTABLE
  
• MARKERTABLE
  
• MAXDISCARDRECS
  
• MAXGROUPS
  
• MAXSQLSTATEMENTS
  
• MAXTRANSOPS
  
• MGRSERVNAME
  
• NAMECCSID
  
• NAMEMATCH parameters
  
• NOCATALOG
  
• NODUPMSGSUPPRESSION
  
• NUMFILES
  
• OBEY
  
• OUTPUTFILEUMASK
  
• OUTPUTFORMAT
  
• OVERRIDEDUPS | NOOVERRIDEDUPS
  
• PTKCAPTUREPROCSTATS
  
• PTKMONITORFREQUENCY
  
• PRESERVETARGETTIMEZONE
  
• PROCEDURE
  
• RECOVERYOPTIONS
  
• REPERROR
  
• REPFETCHEDCOLOPTIONS
  
• REPLACEBADCHAR
  
• REPLACEBADNUM
  
• REPLICAT
  
• REPORT
  
• REPORTCOUNT
  
• REPORTROLLOVER
  
• REPOUDPPORT
  
• RESTARTCOLLISIONS | NORESTARTCOLLISIONS
  
• RMTFILE
  
• RMTHOST
  
• RMTHOSTOPTIONS
  
• RMTTASK
  
• RMTTRAIL
  
• ROLLOVER
  
• SCHEMAEXCLUDE
  
• SEQUENCE
  
• SESSIONCHARSET
  
• SETENV
  
• SHOWSYNTAX
  
• SOURCEDB
  
• SOURCECATALOG
  
• SOURCECHARSET
  
• SOURCEDEFS
  
• SOURCEISTABLE
  
• SOURCETIMEZONE
  
• SPACESTONULL | NOSPACESTONULL
  
• SPECIALRUN
  
• SPLIT_TRANS_REC
  
• SQLDUPERR
  
• SQLEXEC
  
• STATOPTIONS
  
• TABLE | MAP
  
• TABLE for DEFGEN
  
• TABLE for Replicat
  
• TABLEEXCLUDE
  
• TARGETDB
  
• TARGETDEFS
  
• TCPSOURCETIMER | NOTCPSOURCETIMER
  
• THREADOPTIONS
  
• TRACE | TRACE2
  
• TRACETABLE | NOTRACETABLE
  
• TRAILBYTEORDER
  
• TRAILCHARSET
  
• TRAILCHARSETASCII
  
• TRAILCHARSETEBCDIC
  
• TRAIL_SEQLEN_6D | TRAIL_SEQLEN_9D
  
• TRANLOGOPTIONS
  
• TRANSACTIONTIMEOUT
  
• TRANSMEMORY
  
• TRIMSPACES | NOTRIMSPACES
  
• TRIMVARSPACES | NOTRIMVARSPACES
  
• UPDATEDELETES | NOUPDATEDELETES
  
• UPDATEINSERTS | NOUPDATEINSERTS
  
• UPDATERECORDFORMAT
  
• UPREPORT
  
• USE_TRAILDEFS | NO_USE_TRAILDEFS
  
• USEDEDICATEDCOORDINATIONTHREAD
  
• USEIPV4
  
• USEIPV6
  
• USERID | NOUSERID
  
• USERIDALIAS
  
• VAM
  
• VARWIDTHNCHAR | NOVARWIDTHNCHAR
  
• WALLETLOCATION
  
• WARNLONGTRANS
  
• WARNRATE
  
• WILDCARDRESOLVE
  
• XAGENABLE
  
• Y2KCENTURYADJUSTMENT | NOY2KCENTURYADJUSTMENT
  

2.1 COMMIT_SERIALIZATION

Valid For

Parallel Replicat

Description

Enables commit FULL serialization mode, which forces transactions to be committed in trail order. See Basic Parameters for Parallel Replicat in Using Oracle GoldenGate for Oracle Database.

Default

None