ITPub博客

首页 > Linux操作系统 > Linux操作系统 > GoldenGate的一些参数的意义

GoldenGate的一些参数的意义

原创 Linux操作系统 作者:abstractcyj 时间:2013-07-10 14:58:50 0 删除 编辑
1. ASSUMETARGETDEFS - You use this target to tell that your source and and target tables are identical. 
2. ReportCount Every 30 Minutes, Rate
    GoldenGate会统计并报告自启动以来处理的数据复制的条数
    1000 records processed as of 2010-01-28 11:30:40 (rate 154,delta 215) 
     Since the Extract process started, it has processed 1,000 records as of the time displayed (11:30:40).
You also asked for RATE information to be printed in the report. The rate calculations are as follows:
Rate = # of records processed since startup / total time since startup
Delta = # of records since last report / time since last report
In the example, the processing rate is 154 and the delta is 215. The delta is higher, which indicates
that you’re processing more records in the latest reporting period. You can compare the rate over time to
see if it changes. Changes in rate could be due to more or less processing volume or perhaps
performance issues with your Extract or Replicat or even the database itself.
3. REPORTROLLOVER
   循环使用report文件,防止文件过大影响性能
4. PurgeOldExtracts
    清除旧的extract文件。 
    例: PurgeOldExtracts dirdat/*, UseCheckpoints, MinKeepDays 2
    这个配置会清除目录dirdat下的extract文件,USECHECKPOINTS这个选项表示除非extract files已经被处理,否则extract文件不会被清除
5. ENCRYPTTRAIL
   加密extract文件
6. DECRYPTTRAIL
  解密extract文件
7. Table HR.EMPLOYEES
COLS (employee_Id, first_name, last_name);
  这个配置表示对于表HR.EMPLOEES, 只匹配三个包含在COLS选项中的列
8. Table HR.EMPLOYEES
COLSEXCEPT (email);
   抽取employees表的所有列,除了email
9. Map HR.EMPLOYEES, Target HR.EMPLOYEES,
WHERE (JOB_ID = "IT_PROG");
  只replicateJOB_ID = "IT_PROG"的记录
10. FILTER (ON DELETE, SALARY / 12 < 1000);
  在删除操作时,只删除月薪少于1000的员工记录


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8520577/viewspace-765973/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    555
  • 访问量
    828561