oracle中查询被锁的表并开释session
日期：2014-05-16 浏览次数：20506 次
查询sql:
A.
OBJECT_NAME
,
B.XIDUSN,
B.XIDSLOT,
B.XIDSQN,
B.SESSION_ID,
B.ORACLE_USERNAME,?
B.OS_USER_NAME,
B.PROCESS,?
B.LOCKED_MODE,?
C.MACHINE,
C.STATUS,
C.SERVER,
C.SID,
C.SERIAL#,
C.PROGRAM
FROM
?ALL_OBJECTS?A,
V$LOCKED_OBJECT?B,
SYS.GV_$SESSION?C?
WHERE
?(?A.
OBJECT_ID
?
=
?B.
OBJECT_ID
?)
AND
?(B.PROCESS?
=
?C.PROCESS?)
ORDER
?
BY
?
1
,
2
?
释放session Sql:
alter
?system?
kill
?session?
