1.查出锁表的会话
select ,,#,logon_time ,c.object_name,,
from v
l
o
c
k
e
d
o
b
j
e
c
t
a
,
v
locked_object a,v
lockedobjecta,vsession b,dba_objects c
where a.session_id = and a.object_id = c.object_id;
2.–杀会话
alter system kill session ‘sid,serial#’;
3.如果kill 该session不成功则通过session id 查到对应的操作系统进程，在unix中杀掉操作系统的进程。
SELECT , AS os_process_id, AS oracle_process_id FROM v
s
e
s
s
i
o
n
a
,
v
session a,v
sessiona,vprocess c
WHERE = and = : session_id and #= :serial#;
找到linux中进程ID