日期:2014-05-16  浏览次数:20381 次

Oracle解除锁,查看锁的方法
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 '617,19249' immediate;