oracle 表被锁死
-------oracle解锁pid,查找被锁住的pid
SELECT SESS.SID,
SESS.SERIAL#,
LO.ORACLE_USERNAME,
LO.OS_USER_NAME,
AO.OBJECT_NAME,
LO.LOCKED_MODE,
SESS.LOCKWAIT
FROM V
L
O
C
K
E
D
O
B
J
E
C
T
L
O
,
D
B
A
O
B
J
E
C
T
S
A
O
,
V
LOCKED_OBJECT LO, DBA_OBJECTS AO, V
LOCKEDOBJECTLO,DBAOBJECTSAO,VSESSION SESS
WHERE AO.OBJECT_ID = LO.OBJECT_ID
AND LO.SESSION_ID = SESS.SID
ORDER BY SESS.SID;
–将被锁住的pid杀掉
ALTER SYSTEM KILL SESSION ‘1657,46017’;