inactive transaction branch等待事件

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题: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相符

此条目发表在 Oracle性能优化 分类目录。将固定链接加入收藏夹。

inactive transaction branch等待事件》有 3 条评论

  1. Herman 说:

    升级到11.2.0.3.6后,问题依旧存在,悲剧呀!

  2. 惜分飞 说:

    谢谢,已经更正,错误的把qq号写上去了

    错了。。it’s this
    Bug 10413418 – Query with dblink intermittently hang waiting for ‘inactive transaction branch’ [ID 10413418.8]

  3. qcbz 说:

    错了。。it’s this
    Bug 10413418 – Query with dblink intermittently hang waiting for ‘inactive transaction branch’ [ID 10413418.8]