love wife love life —Roger的Oracle/MySQL数据恢复博客

Phone:18180207355 提供专业Oracle/MySQL数据恢复、性能优化、迁移升级、紧急救援等服务

ORA-01591: lock held by in-doubt distributed transaction

本站文章除注明转载外,均为本站原创: 转载自love wife love life —Roger的Oracle/MySQL数据恢复博客

本文链接地址: ORA-01591: lock held by in-doubt distributed transaction

3 Responses to “ORA-01591: lock held by in-doubt distributed transaction”

  1. roger Says:

    SQL> desc x$ktuxe

    Name Null? Type
    —————— ——– —————————-
    ADDR RAW(4)
    INDX NUMBER
    INST_ID NUMBER
    KTUXEUSN NUMBER — undo seq number
    KTUXESLT NUMBER — slot 即为事务槽号
    KTUXESQN NUMBER — sequence号
    KTUXERDBF NUMBER — 文件号 即为file id
    KTUXERDBB NUMBER — block 号
    KTUXESCNB NUMBER — SCN base for prepare/commit
    KTUXESCNW NUMBER — SCN wrap for prepare/commit
    KTUXESTA VARCHAR2(16) — 事务状态 (我所知道的应该是有3种 action,inaction,dead)
    KTUXECFL VARCHAR2(24) — 事务标志
    KTUXEUEL NUMBER — 这里根据我猜测,应该是指用于存放事务的一个列表
    KTUXEDDBF NUMBER — file id
    KTUXEDDBB NUMBER — block number
    KTUXEPUSN NUMBER — parent usn number
    KTUXEPSLT NUMBER — parent solt number
    KTUXEPSQN NUMBER — parent seq#
    KTUXESIZ NUMBER — 用于该事务有多少个undo block(单位是block)

  2. 手动升级9i-10g全步骤 | Says:

    […] lock held by in-doubt distributed transaction […]

  3. About ora-00600 [4400] [48] | love wife & love life ——Roger Says:

    […] 该文档描述说4400错误是跟分布式事务有关,曾经也遇到不少关于分布式事务的问题,以前也 写过一篇:ORA-01591: lock held by in-doubt distributed transaction […]

Leave a Reply

You must be logged in to post a comment.