杀死oracle ebs中死锁的线程

---找到现有线程中的locked_mode 及session_id---

select b.owner,b.object_name,a.session_id,a.locked_mode

from v$locked_object a,dba_objects b

where b.object_id = a.object_id;

---根据session_id 找到serial#  ---

select b.username,b.sid,b.serial#,logon_time

from v$locked_object a,v$session b

where a.session_id = b.sid

and a.SESSION_ID=1494 order by b.logon_time

 

---杀死系统的session 第一个参数是session_id，第二个参数是serial#---

alter system kill session '1494,18120';