library cache lock等待事件P3的意义

overmars

上图是通过dba_hist_active_sess_history查看得到，想问下，为啥P3的值如此大？ 通过P3能通到Lock mode吗？
图片看不清楚，这些写下吧：
event=library cache lock
Event_id=916468430
Seq#=59
P1TEXT=handle address
P1=5.04403183962014E17
P2TEXT=lock address
P2=5.04403177064603E17
P3TEXT=100*mode+namespace
P3=242867515752450    ==我觉得这个P3异常，一般是3位数的
Wait_class=Concurrency

Maclean Liu(刘相兵

create or replace procedure vv
as
begin
execute immediate 'alter procedure vv compile';
end;


create or replace procedure zz
as
begin
execute immediate 'alter procedure zz compile';
end;


exec zz;

exec vv;

     0: waiting for 'library cache pin'
        handle address=0x7ff536a0e80, pin address=0x7ff59750338, 100*mode+namespace=0x1c8a800010003
               
               
               
             0: waiting for 'library cache pin'
        handle address=0x7ff5b61e548, pin address=0x7ff53a85118, 100*mode+namespace=0x1c8a900010003
               
                0x1c8a9 =>116905
                0x1c8a8 => 116904
               
  1* select object_id,object_name from dba_objects  where object_name in ('ZZ','VV')
SQL> /

OBJECT_ID OBJECT_NAME
---------- --------------------
    116905 ZZ
    116904 VV
       
       
             0: waiting for 'library cache pin'
        handle address=0x7ff536a0e80, pin address=0x7ff5beb9890, 100*mode+namespace=0x1c8a800010003         ==>RequestMode=X
               
                     0: waiting for 'library cache pin'
        handle address=0x7ff536a0e80, pin address=0x7ff59a0e278, 100*mode+namespace=0x1c8a800010002        ==>RequestMode=S
               
               
               

Maclean Liu(刘相兵

library cache lock 和 library cache pin  针对 procedure 、function 等PLSQL 对象时（注:10.2.0.3开始cursor默认 使用mutex pin)
看起来p3的公式 其实变了
0x1c8a900010003

==>  (object_id << 32 ) + (namespace << 16) +( mode)

1c8a9  <<32=>11100100010101001 00000000 00000000 00000000 00000000 = 502103151738880

namespace << 16 =>  1 00000000 00000000 = 65536

mode = excl = 3

502103151738880 + 65536 + 3= 0x1C8A900010003

overmars

高。实在是高！