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