oracle 编译存储过程 等待锁定对象 时超时问题解决

1、首先找出SID

select session_id sid, owner, name, type,
mode_held held, mode_requested request
from dba_ddl_locks
where name = 'CUX_PODETAIL_PKG'

2、根据SID找出SERIAL
select b.SID,b.SERIAL# from v$session b where b.SID=41

3、alter system kill session 'SID,SERIAL#';:

alter system kill session '41,4216'