输入banner图图片脚本导航/分类

oracle plsql 上对package 包执行重新编译时,超时无响应:(4021)time-out occurred while waiting to lock object

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