联系:手机(13429648788) QQ(107644445)
链接:https://www.orasos.com/inactive-transaction-branch%e7%ad%89%e5%be%85%e4%ba%8b%e4%bb%b6.html
标题:inactive transaction branch等待事件
作者:惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]
分析一份awr,发现不太熟悉的等待事件”inactive transaction branch”,awr相关信息如下
分析top 1 sql中的对象
SQL> select * from v$version; BANNER ----------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production SQL> select owner,object_type from dba_objects where object_name =upper('wCommonShortMsg'); OWNER OBJECT_TYPE ------------------------------ ------------------- PUBLIC SYNONYM OFFONQUERY SYNONYM SQL> COL DB_LINK FOR A12 SQL> select TABLE_OWNER,TABLE_NAME,DB_LINK from dba_SYNONYMS WHERE 2 SYNONYM_NAME=upper('wCommonShortMsg'); TABLE_OWNER TABLE_NAME DB_LINK ------------------------------ ------------------------------ ------------ WCOMMONSHORTMSG CRMDB_LINK WCOMMONSHORTMSG DB_LINK_CRM
通过这里查询,可以确定引起dblink相关等待严重的是关于wCommonShortMsg同义词查询导致(使用dblink连接到其他库),结合数据库版本,大致可以确定inactive transaction branch等待和MOS中的bug 10413418相符
升级到11.2.0.3.6后,问题依旧存在,悲剧呀!
谢谢,已经更正,错误的把qq号写上去了
错了。。it’s this
Bug 10413418 – Query with dblink intermittently hang waiting for ‘inactive transaction branch’ [ID 10413418.8]