–查询锁表的语句
select * from v
s
e
s
s
i
o
n
t
1
,
v
session t1, v
sessiont1,vlocked_object t2 where t1.sid = t2.SESSION_ID;
–杀掉锁的进程 sid serial#
alter system kill session ‘83,2469’;
—查看被锁存储过程
select * FROM dba_ddl_locks where name =upper(‘存储过程’);
select t.sid,t.serial# from v$session t
where t.sid=40;
得到sid和serial#
最后用alter system kill session ‘40,3993’; kill 相关session即可。
–查询正在执行的存储过程
select * from v$db_object_cache where locks>0 and pins>0 and type=‘PROCEDURE’;