在/goldengate/temp,/goldengate/temp2 目录设置虚拟内存
CHECKPOINTSECS Controls how often Extract writes a checkpoint.
DBOPTIONS Specifies database options.指定对于某种特定数据库所需要的特殊参数
示例:DBOPTIONS ALLOWUNUSEDCOLUMN
--当抽取进程遇到一个没有使用的字段时只生成一个警告,进程会继续执行而不会被异常终止(abend)
DDLOPTIONS Specifies DDL processing options.
DYNAMICRESOLUTION |
NODYNAMICRESOLUTION Suppresses the metadata lookup for a table until Extract encounters transactional data for it. Makes Extract start faster when there are numerous tables specified for synchronization.
示例:DYNAMICRESOLUTION --有时候开启OGG进程的时候较慢,可能是因为需要同步的表太多,OGG在开启进程之前会将需要同步的表建立一个记录并且存入到磁盘中,这样就需要耗费大量的时间。使用该参数来解决此问题。
EOFDELAY | EOFDELAYCSECS Determines how long Extract delays before searching for more data to process.
FLUSHSECS | FLUSHCSECS Determines the amount of time that record data remains buffered before being written to the trail.
FUNCTIONSTACKSIZE Controls the size of the memory stack that is used for processing Oracle GoldenGate functions.
GROUPTRANSOPS Controls the number of records that are sent to the trail in one batch.
LOBMEMORY Controls the amount of memory and temporary disk space available for caching transactions that contain LOB s.
MAXFETCHSTATEMENTS Controls the maximum number of prepared queries that Extract can use to fetch data from the database.
NUMFILES Controls the initial allocation of memory dedicated to storing information about tables to be processed by Oracle GoldenGate.
定义本extract为最大多少张表预留空间,缺省为500,超过500张表需要设定一个比实际表数略大的值。
示例:numfiles 3000
RMTHOSTOPTIONS Specifies connection attributes other than host information for a TCP/IP connection used by a passive Extract group.
THREADOPTIONS Controls aspects of the way that Extract operates in an Oracle Real Application Cluster environment. Supports Oracle.
示例:THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 60000 IOLATENCY 60000
RAC集群中的所有节点必须同步系统时钟。GoldenGate通过比较本地系统的时间和事务提交的时间点来做出关键决策。可以通过NTP来不同系统时间。所有节点上的COMPATIBLE参数设置也必须相同。注:这个参数在Oracle11.2版本后就不再使用了。
TRANLOGOPTIONS Supplies log-processing options.
指定在解析数据库日志时所需要的特殊参数。例如,对于裸设备,可能需要加入下列参数:
示例1: tranlogoptions rawdeviceoffset 0
示例2:TRANLOGOPTIONS CONVERTUCS2CLOBS
&nb