SELECT OBJECT_ID, SESSION_ID, LOCKED_MODE FROM V$LOCKED_OBJECT;
SELECT T2.USERNAME, T2.SID, T2.SERIAL#, T2.LOGON_TIME
FROM V
L
O
C
K
E
D
O
B
J
E
C
T
T
1
,
V
LOCKED_OBJECT T1, V
LOCKEDO?BJECTT1,VSESSION T2
WHERE T1.SESSION_ID = T2.SID
ORDER BY T2.LOGON_TIME;
杀掉session
alter system kill session ‘2767,18895’;
