=5, SID=295
2019-04-24 09:13:02 Process 21 holding: 0000000060009978 "test excl. parent2 l0" lvl=0 whr=6 why=5, SID=295
2019-04-24 09:13:03 2019-04-24 09:13:04 --//21=0x15,与peek看到的一致.
3.手工测试看看函数的返回值 --//session 1: SYS@book> @ exclusive_latch.txt 'test excl. parent2 l0' 0 1 2 60 old 1: SELECT addr laddr FROM v$latch_parent WHERE NAME='&&1' new 1: SELECT addr laddr FROM v$latch_parent WHERE NAME='test excl. parent2 l0'
LADDR ---------------- 0000000060009978
Statement processed. Function returned 1 Function returned 0
--//session 2: SYS@book> @ exclusive_latch.txt 'test excl. parent2 l0' 0 3 4 6 old 1: SELECT addr laddr FROM v$latch_parent WHERE NAME='&&1' new 1: SELECT addr laddr FROM v$latch_parent WHERE NAME='test excl. parent2 l0'
LADDR ---------------- 0000000060009978
Statement processed. Function returned 0
ORA-00600: internal error code, arguments: [510], [0x060009978], [test excl. parent2 l0], [], [], [], [], [], [], [], [], []
--//可以发现申请成功函数返回值是1.失败是0.只所以session 2报错主要原因是没有申请成功,kslfre肯定报错.
4.看看latch统计信息的情况: SYS@book> select addr,name,level#,latch#,gets,misses,sleeps,immediate_gets,immediate_misses,waiters_woken,waits_holding_latch,spin_gets,wait_time from v$latch_parent where lower(name) like '%'||lower('test excl. parent2 l0')||'%'; ADDR NAME LEVEL# LATCH# GETS MISSES SLEEPS IMMEDIATE_GETS IMMEDIATE_MISSES WAITERS_WOKEN WAITS_HOLDING_LATCH SPIN_GETS WAIT_TIME ---------------- --------------------- ------ ---------- ---------- ---------- ---------- -------------- ---------------- ------------- ------------------- ---------- ---------- 0000000060009978 test excl. parent2 l0 0 5 4 0 0 4 3 0 0 0 0
--//重复测试: $ . y1.sh 20190424094217 [3]- Done sqlplus / as sysdba <<< "@ exclusive_latch.txt 'test excl. parent2 l0' 0 1 2 6" > /dev/null [1] Done source peek.sh 'test excl. parent2 l0' 20 | timestamp.pl >|/tmp/peekx_${ |