ogg 通过 info 查询 Lag at Chkpt／Time Since Chkpt 说明

diff b/w Lag at Chkpt and Time Since Chkpt

https://community.oracle.com/thread/3948669

例如： 

GGSCI (rac1) 2> info all

 

Program     Status      Group       Lag at Chkpt  Time 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 the Time 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) and the timestamp of that record in the data source.

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

通过info命名查看，是离散变化的。其变化值，通常为<Lag at Checkpoint>发生变化之前<Time Since Checkpoint>的值。

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命名查看，是离散变化的。其变化值，通常为<Lag at Checkpoint>发生变化之前<Time Since Checkpoint>的值。

且对于replicat的lag最为常见。

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

转载于:http://blog.itpub.net/30393815/viewspace-2122708/