问题发生在一个用户上,使用这个用户登录需要等待很长时间,而使用其他的用户登录则不存在问题,查看等待事件发现:
SQL> set linesize 200
SQL> select sid,p1, P1RAW,p2,p3,event from v$session_wait where event like '%library cache%';
SID P1 P1RAW P2 P3 EVENT
---------- ---------- ---------------- ---------- ---------- ----------------------------------------------------------------
45 3999290432 00000000EE605440 3997366320 5177346 library cache lock
49 3999290432 00000000EE605440 3994244816 5177346 library cache lock
SQL> select sid, serial#,username, blocking_session, event
from v$session
where event like '%library cache%' 2 3
4 ;
SID SERIAL# USERNAME BLOCKING_SESSION EVENT
---------- ---------- ------------------------------ ---------------- ----------------------------------------------------------------
22 143
11g 密码错误延迟验证引发的library cache lock
最新推荐文章于 2024-01-10 15:36:21 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)