Oracle锁

--表锁

select object_name,machine,s.sid,s.serial#
from v$locked_object l,all_objects  o ,v$session s
where l.object_id = o.object_id and l.session_id=s.sid;

alter system kill session '127,3476'; 

 

--存储过程锁

select * from v$access where owner='用户' AND OBJECT ='存储过程名'
select sid,serial#,paddr from v$session where sid='358';
alter system kill session '358,30086' IMMEDIATE;