查看OGG当前正在处理的事物

> send extract ext_ntt,showtrans

Sending SHOWTRANS request to EXTRACT EXT_NTT …

Oldest redo log file necessary to restart Extract is:

Redo Thread 1, Redo Log Sequence Number 7, SCN 0.985972 (985972), RBA 14440464

---

XID: 7.31.700
Items: 2
Extract: EXT_NTT
Redo Thread: 1
Start Time: 2018-11-26:14:41:17
SCN: 0.985975 (985975)
Redo Seq: 7
Redo RBA: 14441488
Status: Running

select s.sid from v$transactiont,v$session s where s.saddr=t.ses_addr and t.xidsqn=‘700’;

查看应用进程的情况,已经可以看到大事务的数据处理了。
> send rep_test,status
Sending STATUS request to REPLICAT REP_TLBB …
Current status: Processing data
Sequence #: 37
RBA: 45790084
3352129 records in current transaction