首页 » OGG » GOLDENGATE 12.2 Undocumented parameters(隐藏参数)

GOLDENGATE 12.2 Undocumented parameters(隐藏参数)

goldengate 像数据库一样存在大量的隐藏参数,12.2 版本隐藏参数数量超过了200个, 但是这些参数并不是像ORACLE DATABASE一样公开了参数的描述作用,而且研究的人也不多,GOOGLE和MOS上很多参数都查不出相关信息, 后续会对我使用或了解的隐藏作更新.

WARNING! Using undocumented parameters without the consent of Oracle can make your system un-supported and you may be on your own if you experience data corruption.

 

_ABENDONUNSUPPORTED
_ADDNATIVE
_ADGAPPLYCHECKFREQ
_ALIGNMENTBYTES
_ALLOW3PARTNAMES
_ALLOWDEFAULTSCHEMA
_ALLOWDORMANTCOMPRESSEDOBJECT
_ALLOWDUPSECONDARYXID
_ALLOWIMURECORDS
_ALLOWMISMATCHEDROLLBACKID
_ALLOWMISSINGROWCOLLISIONS
_ALLOWPKMISSINGROWCOLLISIONS
_ALLOWTABLECOMPRESSION
_ALLOWWILDCARDSCHEMAS
_ALLOW_DATA_LOSS
_ALLOW_WILD_CARD_SCHEMAS
_ALTRESETLOGSCHANGENUMBER
_ALTRESETLOGSID
_APC_LCR_BUFFER_SIZE
_APPLY_SAFETY_LEVEL
_APR_APC_BUFFER_SIZE
_APR_LCR_BATCH_SIZE
_ARRAY_OPERATION
_BATCHERRORMODE
_BATCHESPERQUEUE
_BATCHTRANSOPS
_BINDCHARASBINARY
_BINDCHARASCHAR
_BRCLEANUP
_BRDEBUG
_BREXEC
_BRVMF
_BUFFERREAD
_BUFSIZE
_BYPASS_PARTITION_READONLY
_BYTESPERQUEUE
_CACHEALLSQL
_CACHEDBCONNECTIONS
_CACHE_ALL_SQL
_CALCUTF8BYTELENGTH
_CALC_UTF8_BYTE_LENGTH
_CASESENSITIVE
_CASE_SENSITIVE
_CDR_CHECK_NULL
_CHECKNULL
_CHECKRACONSCNINCREMENT
_CHECKTTY
_CLIENT_TABLE_DEFN_SIZE
_COMCAST
_COMMIT_SERIALIZATION_PERIOD
_COMPUTE_ROW_LEVEL_BITMAP_DEP
_CONVERTBADNUMBER
_CQUEUELCRPOSTTHRESHOLD
_CSNDUPNUM
_CSNFILTERING
_CSN_DUP_NUM
_CSN_FILTERING
_DATA_LAYER
_DBFILTERDDL
_DEBUGMONITORAGENT
_DEBUG_MONITOR_AGENT
_DEFAULTJOURNAL
_DFTJRN
_DICTLOADLOGGINGFREQ
_DICTLOGLOOPTIMEOUT
_DIRECT_PATH
_DISABLEFIX21427144
_DISABLENOMETAEXEC
_DISABLESUPPLOGCHECK
_DISABLE_FIX_21427144
_DLFAILOVERQUERYFREQ
_DML_REORDER
_DONTCACHEDBCONNECTIONS
_DYNAMIC_STMTS
_EMBEDQUOTE
_EMPTYTOSPACE
_ENABLESTREAMLINEDDBLOGREADER
_ENABLE_HASH_SERVER
_ENABLE_INMEM_APT
_ENQUEUE_ERROR_LCRS
_EVENTSIMPROPMISSING
_EVENTSIMPROPMISSING1
_FAILOVERTARGETDESTID
_FASTREADS
_FETCHCHAINEDUPDATES
_FIRE_CROSSEDITION_TRIGGERS
_FORCEASM
_FORCEFETCHLONGCOLUMN
_FORCESKIPOPERATION
_GETHOSTNAMES
_GLOBALSQLEXEC
_HANGATPROGRAMSTART
_HANGONFATALERROR
_HANG_AT_PROGRAM_START
_HANG_ON_FATAL_ERROR
_HASH_TABLE_SIZE
_IDLETIMEOUT
_IGNOREDISABLEDFKS
_IGNOREOPENTRANSACTIONS
_IGNORESCNSEQUENCE
_IGNORETHREADEVENT
_IGNORETSERECORDS
_IGNOREUNSUPPORTEDUDTTYPES
_IGNORE_CONSTRAINTS
_IGNORE_TRUNCATED_DDL
_IGNORE_UNSUPPORTED_UDT_TYPES
_INFINITYTOZERO
_INITBLOCKSIZE
_INTERNALLCR
_INVALIDRECSDURINGRECOVERY
_IOLATENCY
_KEYFIRST
_KEY_BASED_QUERY
_KGL_CACHE_SIZE
_LCRASYNCREADAHEAD
_LCRASYNCREADARRAYRECEIVE
_LCRASYNCREADCACHEWARMUP
_LCRASYNCREADNOCACHEWARMUP
_LCRASYNCREADWAITBATCH
_LCRCAPTUREPROTOCOL
_LCRPINGFREQUENCY
_LCR_CACHE_PURGE_PERIOD
_LCR_CACHE_PURGE_RATIO
_LEFQUERYDELAY
_LOBCONDAPPLY
_LOB_ASSEMBLY
_LOB_COND_APPLY
_LOGALLSUPPCOLS
_LOG_ALL_SUPP_COLS
_MAXCOMMITPROPAGATIONDELAY
_MAXLOBCHUNKSIZE
_MAXSEQUENCEDISTANCE
_MAXSTATECHANGEWAITTIME
_MAXTRANSOPS
_MAX_HASH_ENTRIES_PER_TXN
_MEMIDDECREASING
_MEMORYPERCENTAGE
_MIN_USER_AGENTS
_NEWRESUME
_NFSIOLATENCY
_NOABENDONUNSUPPORTED
_NOARCHIVEDLOGONLY
_NOASSEMBLEPARTIALLOB
_NOAUTOMATICSEQUENCEFLUSH
_NOAUTORECFORMAT
_NOBRCLEANUP
_NOBUFFERREAD
_NOCALCNLOBLENGTH
_NOCHECKNULL
_NOCHECKRACONLWB
_NOCHECKTTY
_NOCHECKVERSION
_NOCMPMODCOL
_NODBFILTER
_NODBFILTERDDL
_NODISABLEONRETRYERROR
_NODISABLEORRETRYERROR
_NOFASTREADS
_NOFETCHCHAINEDUPDATES
_NOFILE
_NOFORCEASM
_NOFORCEFETCHLONGCOLUMN
_NOIGNOREORPHANLMN
_NOIND
_NOINFORMIXCASTFUNCSFORHTML
_NOINFORMIXFIXPMRFC4
_NOINVALIDRECSDURINGRECOVERY
_NOKEEPOLDSUPPLOG
_NOLCRASYNCREADARRAYRECEIVE
_NOLCRASYNCREADWAITBATCH
_NOLOGBSN
_NOMARKEDTRANSACTION
_NOMERGEMEMBERS
_NONATIVE
_NONEWRESUME
_NOODIRECT
_NOOP
_NOOPENARCHIVEIMMEDIATE
_NOOPTIMIZEROWMIGRATION
_NORAC
_NOREADAHEAD
_NOREOPENONREAD
_NOREVERSEGUID
_NOSKIPORASCRIPT
_NOSQLCACHE
_NOSQLNCLITRANSACTIONRENAMING
_NOSYNCSOURCETRAILONCHKPT
_NOSYSKEY
_NOTS
_NOUPDATELWM
_NOUSEEDITION
_NOUSETRIGGERMETADATA
_NO_ABEND_ON_UNSUPPORTED
_NO_AUTOMATIC_SEQUENCE_FLUSH
_NO_AUTO_REC_FORMAT
_NO_CALC_NLOB_LENGTH
_NO_CHECK_NULL
_NO_CMP_MOD_COL
_NO_DISABLE_ON_RETRY_ERROR
_NO_DISABLE_OR_RETRY_ERROR
_NO_SQL_CACHE
_NO_USE_TRIGGER_METADATA
_ODBC_UNIX_UTF16
_OPENARCHIVEIMMEDIATE
_OPSPERBATCH
_OPSPERQUEUE
_OVERRIDETHREADCOUNTCHECK
_PARALLEL_BATCH
_PARTITION_SIZE
_PERSIST_APPLY_STATS
_PRECISE_DEP_HASH
_RAWDEVICEOFFSET
_READAHEADCOUNT
_RECALCULATE_MAX_INST_SCN
_RECORD_LWM_INTERVAL
_RELOADTHREADCACHE
_REOPENONREAD
_RESTRICT_ALL_REF_CONS
_RESUMEAFTERBATCHERROR
_RETRYCOUNT
_RETRYDELAYMS
_SCHEDULING_HINT_LEVEL
_SESSIONPOOLTIMEOUT
_SESSION_POOL_TIMEOUT
_SHARED_TXN_STATE
_SKIPDDL
_SKIPORASCRIPT
_SOURCE_REDO_COMPATIBLE
_SQLPLUS
_STATS_INTERVAL
_STMTCACHESIZE
_SYNCSOURCETRAILONCHKPT
_TESTMAPPINGSPEED
_TESTONLYMONITORAGENT
_TEST_ONLY_MONITOR_AGENT
_TRAILBUFFERSIZE
_TRAILCHARSET
_TRAILINBUFFERSIZE
_TRAILOUTBUFFERSIZE
_TXN_BUFFER_SIZE
_UNSUPPORTEDLCROPTION
_UNSUPPORTED_LCR_OPTION
_USEALLKEYCOLUMNS
_USEOID
_USETRIGGERMETADATA
_VALIDATEPKUPDATE
_VALIDATE_PK_UPDATE
_VECTOR_POST
_WHOLEFILE
_XML_SCHEMA_USE_TABLE_OWNER
__CACHEFORCE
__CACHEHIDDEN
__CACHEMAXOSVM
__CACHEMMAPFATAL
__CACHENORMALVAL
__CACHEOSGRAIN
__CACHEPAGEOUTSIZE
__CACHESIZEFORCE
__CACHEVMF
__CACHEWAITFORDEBUGGER
__CMREGRESS

tip: source libggparam.so file in OGG location

打赏

对不起,这篇文章暂时关闭评论。