橙子不夏天

学习,记录

导航

oracle解锁表

Posted on 2014-08-20 16:23  橙子不夏天  阅读(93)  评论(0编辑  收藏  举报

select b.owner,b.object_name,a.session_id,a.locked_mode,c.serial#,c.sid||','||c.serial#
from v$locked_object a,dba_objects b ,v$session c
where b.object_id = a.object_id
And a.session_id = c.sid
 

alter system kill session '1161,4464' immediate;