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
aux: 11.2.0.1
linkdb:
![bb](http://img.blog.itpub.net/blog/attachment/201408/19/24867586_1408411817E9c9.jpg?x-oss-process=style/bb)
SP执行于11.2.0.3版本,通过link执行如下sql
![bb](http://img.blog.itpub.net/blog/attachment/201408/19/24867586_1408412004NWBj.jpg?x-oss-process=style/bb)
oracle对ora-02049解释:
![bb](http://img.blog.itpub.net/blog/attachment/201408/19/24867586_1408412075aUbL.jpg?x-oss-process=style/bb)
问题处理过程以及分析:
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24867586/viewspace-1253628/