1、查看被锁表进程
SELECT /*+ rule*/
a.sid, b.owner, object_name, object_type
FROM v$lock a, all_objects b
WHERE TYPE = 'TM'
and a.id1 = b.object_id;
2、查被锁定这个对象的用户,使用上一步的sid
select spid, osuser, s.program
from v$session s,v$process p
where s.paddr=p.addr and s.sid=52
3、查出sid和serial
select sid, serial#, machine, program from v$session where sid=52
4、使用上一步的sid,serial 杀死会话,
alter system kill session 'sid,serial#'
alter system kill session '52,4369'