当前位置：Gxlcms >
数据库问题 >
oracle plsql 上对package 包执行重新编译时，超时无响应：(4021)time-out occurred while waiting to lock object
oracle plsql 上对package 包执行重新编译时，超时无响应：(4021)time-out occurred while waiting to lock object
时间：2021-07-01 10:21:17
帮助过：113人阅读
SELECT * FROM V$ACCESS
WHERE OBJECT
=‘CMSVOUCHER‘;
select * from dba_ddl_locks
where name
=‘CMSVOUCHER‘;
根据SID号查出会话信息：
select sid,serial#
from v$session
where sid
in(
‘78‘,
‘209‘);
kill掉：
alter system
kill session
‘78,4883‘;
alter system
kill session
‘209,57021‘;
重新编译了包和包体--编译成功，包debug调试正常。问题到此解决。
oracle plsql 上对package 包执行重新编译时，超时无响应：(4021)time-out occurred while waiting to lock object
标签：div bsp red code 自动 debug access exec span
