-- p_CC存储过程名称
select * FROM dba_ddl_locks where name =upper('P_CC');
-- 从而得到session_id
select t.sid,t.serial# from v$session t where t.sid='12';
--通过得到sid和serial#最后用 kill 相关session即可
alter system kill session 'sid,serial#';
oracle存储过程解除死锁-- p_CC存储过程名称select * FROM dba_ddl_locks where name =upper('P_CC');-- 从而得到session_idselect t.sid,t.serial# from v$session t where t.sid='12';--通过得到sid和serial#最后用 kill 相关session即可alter system kill session 'sid,serial#';...