[ERROR] WARNING OGG-01027 Long Running Transaction

OGG同步出现很多长事务警告：WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ext_txt.prm:  Long Running Transaction: 

查看ggser.log日志 ：
 

2015-10-22 16:58:01  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ext_txt.prm:  Long Running Transaction: XID 11.26.3180361, Items 0, Extract EXT_TXT, Redo Thread 1, SCN 5.977292328 (22452128808), Redo Seq #30582, Redo RBA 290958864.

2015-10-22 17:08:02  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ext_txt.prm:  Long Running Transaction: XID 11.26.3180361, Items 0, Extract EXT_TXT, Redo Thread 1, SCN 5.977292328 (22452128808), Redo Seq #30582, Redo RBA 290958864.

2015-10-22 17:18:02  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ext_txt.prm:  Long Running Transaction: XID 11.26.3180361, Items 0, Extract EXT_TXT, Redo Thread 1, SCN 5.977292328 (22452128808), Redo Seq #30582, Redo RBA 290958864.

2015-10-22 17:28:02  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, ext_txt.prm:  Long Running Transaction: XID 11.26.3180361, Items 0, Extract EXT_TXT, Redo Thread 1, SCN 5.977292328 (22452128808), Redo Seq #30582, Redo RBA 290958864.

从上面可以看到大量的长事务警告，为什么ogg会触发这个警告呢！这是由于我们在抽取进程中配置了WARNLONGTRANS 2H,CHECKINTERVAL 10m 参数，这个参数表上每隔10分钟检测一次，如果超过两个小时未执行完就会触发长事务警告。通过如下方式，查找什么事务导致的：

select addr from v$transaction where XIDUSN||XIDSLOT||XIDSQN=11263180361;

select prev_sql_id from v$session where taddr in ('0000001167C3F3C0');

select * from v$sqlarea sa where sa.SQL_ID='g72kdvcacxvtf';

通过上述命令可以查找到一条这样得sql：DELETE FROM PLAN_TABLE WHERE STATEMENT_ID=:1

这个sql是执行计划的一个中间表。从而想到了自己在测试sql开启了一个会话，从下午两点到下班一直开着这个会话，从而导致ogg误以为是长事务发出警告，退出会话就ok。