博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
DYNAMICRESOLUTION | NODYNAMICRESOLUTION
阅读量:6644 次
发布时间:2019-06-25

本文共 1354 字,大约阅读时间需要 4 分钟。

有时候开启OGG进程的时候较慢,可能是由于须要同步的表太多,OGG在开启进程之前会将须要同步的表建立一个记录而且存入到磁盘中,这样就须要耗费大量的时间。OGG同一时候也提供了DYNAMICRESOLUTION | NODYNAMICRESOLUTION參数来解决问题,看官方怎样描写叙述的:

DYNAMICRESOLUTION | NODYNAMICRESOLUTION
Valid for Extract and Replicat
Use the DYNAMICRESOLUTION and NODYNAMICRESOLUTION parameters to control how table
names are resolved.
Use DYNAMICRESOLUTION to make processing start sooner when there is a large number of
tables specified in TABLE or MAP statements. By default, whenever a process starts, Oracle
GoldenGate queries the database for the attributes of the tables and then builds an object
record for them. The record is maintained in memory and on disk, and the process of
building it can be time-consuming if the database is large.
DYNAMICRESOLUTION causes the object record to be built one table at a time, instead of all at
once. A table’s attributes are added to the record the first time its object ID enters the
transaction log, which occurs with the first extracted transaction on that table. Recordbuilding
for other tables is deferred until activity occurs. DYNAMICRESOLUTION is the same as
WILDCARDRESOLVE DYNAMIC.
NODYNAMICRESOLUTION causes the object record to be built at startup. This option is not
supported for Teradata. NODYNAMICRESOLUTION is the same as WILDCARDRESOLVE IMMEDIATE.
For more information about WILDCARDRESOLVE, see page 389.

转载地址:http://laevo.baihongyu.com/

你可能感兴趣的文章
linux下配置LAMP开发环境,以及经常使用小细节
查看>>
程序员的出路0
查看>>
关于Unity中UI中的RawImage节点以及制作地图滚动效果
查看>>
HiWorkV1.3版震撼公布,今日起正式公开測试!
查看>>
(七)Thymeleaf的 th:* 属性之—— th: ->设值& 遍历迭代& 条件判断
查看>>
linux 线程切换效率与进程切换效率相差究竟有多大?
查看>>
Tensorflow一些常用基本概念与函数
查看>>
2014中国民营企业500强在京津冀经济区、珠江三角洲、长江三角洲分布
查看>>
【JEECG技术博文】JEECG 简单实例解说权限控制
查看>>
如果想从jenkins直接生成docker镜像,并推送到harbor中,最简单的脚本如何实现?...
查看>>
条件随机场CRF(二) 前向后向算法评估标记序列概率
查看>>
codecombat之边远地区的森林1-11关及地牢38关代码分享
查看>>
小米2S电池电量用尽充电无法开机解决方法
查看>>
确定性这剂毒药,你喝过没
查看>>
GODOT 3.0 开发进度汇报 #6
查看>>
c#简单写售票系统
查看>>
简单RPC框架-业务线程池
查看>>
Swift iOS tableView static cell动态计算高度
查看>>
POJ - 3164 Command Network(朱刘算法)
查看>>
phalcon:官方多模块支models层,mode数据库配置
查看>>