key words: 鎖表 解鎖
查詢sql:
SELECT?A.OWNER,
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?'sid,?serial#'
alter?system?kill?session?'379,?21132'
alter?system?kill?session?'374,?6938'