SQL> create or replace procedure binzhang_t is
2 begin
3 dbms_output.put_line('hello');
4 dbms_lock.sleep(12000);
5 end;
6 /
Procedure created.
SQL> create or replace procedure binzhang_t is
2 begin
3 dbms_output.put_line('hello');
4 dbms_lock.sleep(12000);
5 end;
6 /
create or replace procedure binzhang_t is
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object
Elapsed: 00:15:00.00
SQL> select event,SECONDS_IN_WAIT from v$session_wait where wait_class<>'Idle';
EVENT SECONDS_IN_WAIT
------------------------------ ---------------
SQL*Net message to client 0
library cache pin 100
SQL*Net more data from dblink 1196934
SQL*Net message to client 0
网络上有人说是5分钟,我实验了下大约是15分钟。
而且这个错误的提示,timeout occurred while waiting to lock object,比较让人误解是在获取library cache lock的时候发生的,其实根据实验看出pin也一样会发生。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22034023/viewspace-687249/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22034023/viewspace-687249/