1。有可能是你的的执行过程花费的时间太长了
2。查询死锁的进程的方法如下:
select t2.username,b.object_name, t2.sid, t2.serial#, t2.logon_time,t2.TYPE
from v$locked_object t1, v$session t2,all_objects b
where t1.session_id = t2.sid
and t1.OBJECT_ID = b.object_id
and b.object_type = 'TABLE'
order by t2.logon_time;
3。杀死进程方法,必须要有DBA的权限
alter system kill session '139,36119' --sid,serial