Library cache pin :
P1=handle address
P2=lock address
p3=mode * 100 + namespace
SQL> select sid,blocking_session,p1,p1raw,p2,p3,event from v$session where event not like '%message%' and sid in (20,1137,22);
SID BLOCKING_SESSION P1 P1RAW P2 P3 EVENT
---------- ---------------- ---------- ---------------- ---------- ---------- ----------------------------------------------------------------
20 537557208 00000000200A78D8 293 0 latch: shared pool
22 1137 832829180 0000000031A3F6FC 618590516 3.2728E+14 library cache lock
1137 20 832829180 0000000031A3F6FC 831962136 3.2728E+14 library cache pin
libaray cache lock:
P1=handle address
P2=lock address
p3=mode * 100 + namespace
327280000000000
set e
科学记数法
最新推荐文章于 2024-11-29 08:53:43 发布