ogg：Extract 进程遇长事务执行 Forcestop 引发的惨案

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

 

posted @ 2017-07-18 14:11 酸奶加绿茶 阅读( ...) 评论( ...) 编辑 收藏