ORA-02049: timeout: distributed transaction waiting for lock

target : 11.2.0.3
aux:  11.2.0.1

linkdb:


SP執行於11.2.0.3版本，通過link執行如下sql


oracle對ora-02049解釋：
 

問題處理過程以及分析：
SELECT   /*+ RULE */
        LPAD (' ', DECODE (L.XIDUSN, 0, 3, 0)) || L.ORACLE_USERNAME
              USER_NAME,
           O.OWNER,
           O.OBJECT_NAME,
           O.OBJECT_TYPE,
           S.SID,
           S.SERIAL#,
           S.USERNAME,S.OSUSER,S.MACHINE,S.LOGON_TIME
    FROM   V$LOCKED_OBJECT L, DBA_OBJECTS O, V$SESSION S
   WHERE   L.OBJECT_ID = O.OBJECT_ID AND L.SESSION_ID = S.SID
   AND O.OBJECT_NAME='MASTER_HR_H_INFO'
ORDER BY   O.OBJECT_ID, XIDUSN DESC;

  kill -9

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24867586/viewspace-1253628/，如需轉載，請註明出處，否則將追究法律責任。