oracle查找以及杀死锁表对象

1: 查找锁表用户. 用户id, 序列号

select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid order by t2.logon_time;

 

2: 杀死用户.

881为用户id. 4052为序列号.

 

alter system kill session '881,4052';