ogg:Extract 进程遇长事务执行 Forcestop 引发的惨案
http://www.linuxidc.com/Linux/2015-04/115777.htm
SQL> select t.addr,t.START_DATE from v$transaction t;
ADDR START_DAT
---------------- ---------
0000000136AED710 14-JUL-17
SQL> select t.PREV_SQL_ID from v$session t where taddr='0000000136AED710';
PREV_SQL_ID
-------------
03pf17fpsva6s
SQL> select sql_text from v$sqltext t where t.sql_id='03pf17fpsva6s';
SQL_TEXT
----------------------------------------------------------------
UPDATE ACTIVEMQ_LOCK SET TIME = :1 WHERE ID = 1
SQL> select t.SID,t.MACHINE,t.PROGRAM from v$session t where taddr='0000000136AED710';
SID MACHINE PROGRAM
---------- ----------------------- -----------------------------------------
141 localhost.localdomain JDBC Thin Client