Oracle查看ogg延时,ogg 通过 info 查询 Lag at Chkpt/Time Since Chkpt 说明

diff b/w Lag at Chkpt and Time Since Chkpt

例如:

GGSCI (rac1) 2> info all

Program     Status      GroupLag at ChkptTime Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EPMPCE      00:00:00      01:07:30

EXTRACT     RUNNING     EXTCEN      190:43:12     00:00:09

REPLICAT    RUNNING     RORAYT      00:00:00      00:00:09

Time Since Checkpoint

==================

指ogg的extract或replicat进程,产生最近一个检查点的时间与当前的系统时间差。

该值可以通过info看到是在不断变化(特别是当处理长会话时,会持续增长,直到处理完该长会话)

Each process has it's own checkpoint file. Whenever a process see's a commit in the transaction, a checkpoint is made in the checkpoint file. This ensures that, the process to get recovered or to know the last transaction processed by the transaction by viewing it's checkpoint file.(ogg的每个进程都有它自己的checkpoint file。每当一个进程看到在事务的commit时,检查点文件中就将产生一个检查点。ogg的恢复进程总是以检查点作为起点。)

If you stop a Extract process at 10:00AM and restart it at 10:30 AM, upon restarting, the Extract process reads it's checkpoint file to know the last successful processed transaction. So it starts processing the transaction after that checkpoint.

You can see the increase in theTime Since Checkpoint, when extract or replicat is processing a long running transaction. By using the send extract or send replicat command you can know the exact status of the processes. The INFO command always fetches the information from the checkpoint file where as the SEND command communicates directly with the process and gets the current/latest status of it.

This is the reason why you need to have all the archive logs place when you start the process after a long time. The redo may get flushed and it searches for the archive logs.

Lag at Checkpoint

================

For Extract, lag is the difference, in seconds,between the time that a record was processed(最后一个检查点处理的最后一条记录)by Extract (based on the system clock)andthe timestamp of that record in the data source.

最后一个检查点处理的最后一条记录时间戳与data source记录的时间戳之差,所以该值只有当发生检查点之后才会变化。

通过info命名查看,是离散变化的。其变化值,通常为发生变化之前的值。

For Replicat, lag is the difference, in seconds, between the time that the last record was processed by Replicat (based on the system clock) and the timestamp of the record in the trail.

最后一个检查点处理的最后一条记录时间戳与trail文件记录的时间戳之差,所以该值只有当发生检查点之后才会变化。

通过info命名查看,是离散变化的。其变化值,通常为发生变化之前的值。

且对于replicat的lag最为常见。

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值