若两个会话上持续编译相同的Procedure,则等待事件为?
SQL> select sid,event,p1,p1raw,p2,p3 from v$session where event not like '%message%';
SID EVENT P1 P1RAW P2 P3
---------- ------------------------------ ---------- ---------------- ---------- ----------
1627 library cache lock 2171998096 0000000081760F90 2196963904 301
1628 library cache lock 2171998096 0000000081760F90 2196895944 301
1631 Streams AQ: qmn slave idle wai 0 00 0 0
t
1633 Streams AQ: qmn slave idle wai 0 00 0 0
t
1634 Streams AQ: waiting for time m 0 00 0 0
anagement or cleanup tasks
SID EVENT P1 P1RAW P2 P3
---------- ------------------------------ ---------- ---------------- ---------- ----------
1637 Streams AQ: qmn slave idle wai 0 00 0 0
t
1641 Streams AQ: qmn coordinator id 0 00 0 0
le wait
1649 smon timer 300 000000000000012C 0 0
1651 log file parallel write 1 0000000000000001 31 1
1655 pmon timer 300 000000000000012C 0 0
10 rows selected.
SQL> select user_name,
kglnaobj "Owner",
kgllkses saddr,
kgllkreq req,
kgllkmod mod,
kglnaobj object
from x$kgllk lock_a
where kgllkmod > 0
and exists (select lock_b.kgllkhdl
from x$kgllk lock_b
where lock_a.kgllkhdl = lock_b.kgllkhdl
and kgllkreq > 0)
2 3 4 5 6 7 8 9 10 11 12 13 ;
SQL> /
USER_NAME Owner SADDR REQ MOD OBJECT
-------------------- -------------------- ---------------- ---------- ---------- ------------------------------------------------------------
TEST LIB_TEST 0000000089917730 0 3 LIB_TEST
TEST LIB_TEST 00000000899161C8 0 3 LIB_TEST
SQL> select saddr,sid,username,event,p1,p1raw,p2,p3 from v$session where event='library cache lock';
SADDR SID USERNAME EVENT P1 P1RAW P2 P3
---------------- ---------- ------------------------------ ------------------------------ ---------- ---------------- ---------- ----------
00000000899161C8 1627 TEST library cache lock 2171998096 0000000081760F90 2196963904 301
0000000089917730 1628 TEST library cache lock 2171998096 0000000081760F90 2196895944 301