OGG复制进程不报错hang住问题

之前OGG运维过程中有一条复制进程hang住，查view report 没有任何信息，ggserr.log 也没有查到任何信息，使用logdump工具跳到目前执行的rba号，查看是哪个用户哪张表。

 排查后发现OGG出现这种情况大概率是因为长事务导致SQL堵塞，OGG无法执行后续SQL语句。

首先要停止hang住的链路进程

kill <进程> 

然后进查询长事务
with transaction_details as
( select inst_id
, ses_addr
, sysdate - start_date as diff
from gv$transaction
)
select s.username
, to_char(trunc(t.diff))
|| ' days, '
|| to_char(trunc(mod(t.diff * 24,24)))
|| ' hours, '
|| to_char(trunc(mod(t.diff * 24 * 60,24)))
|| ' minutes, '
|| to_char(trunc(mod(t.diff * 24 * 60 * 60,60)))
|| ' seconds' as transaction_duration
, s.program
, s.terminal
, s.status
, s.sid
, s.serial#
from gv$session s
, transaction_details t
where s.inst_id = t.inst_id
and s.saddr = t.ses_addr
order by t.diff desc;

找到对应的 sid  serial#

杀掉对应进程alter system kill session 'sid,serial#';

start <进程>链路恢复