[20220228]enq TX - allocate ITL entry的测试3.txt
[20220228]enq TX - allocate ITL entry的测试3.txt
--//上个星期的测试有点乱,重新规划测试.
1.环境:
SCOTT@book> @ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
create table t ( x int primary key, y varchar2(4000)) PCTFREE 0 INITRANS 169 TABLESPACE users;
insert into t (x,y) select rownum, rpad('*',10,'*') from dual connect by level <= 171;
commit ;
--//可以发现记录在同一块中,共171条记录.
--//前面的测试使用同一会话,最后死锁结束,换1个方式测试看看.
2.建立测试脚本:
$ cat itl_3.txt
set head off
set verify off
set feedback off
column x format 999999
host sleep $(echo &&1/5 | bc -l )
select 'ITL'||&1,s.sid,s.serial# ,s.process,s.server,p.spid from v$session s,v$process p where s.sid in (select sid from v$mystat where rownum=1) and s.paddr=p.addr;
select x from t where x = &&1 for update ;
host sleep 3000
commit ;
quit
--//注执行前加入sleep ,保证执行顺序.
$ zzdate
trunc(sysdate)+08/24+46/1440+37/86400 == 2022/02/28 08:46:37 == timestamp'2022-02-28 08:46:37'
$ seq 169 | xargs -IQ echo "sqlplus -s -l scott/book @itl_3.txt Q &" | bash | tee /tmp/itl.txt
--//等待169/5 = 33.8秒后,保证全部回话执行itl_3.txt的脚本执行到select * from t where x = &&1 for update ;
$ cat /tmp/itl.txt | awk '/ITL/{print $1}' | diff <(cut -c4- ) <(seq 169)
--//执行顺序一致.
--//打开新的会话执行如下:
SCOTT@book> @ spid
SID SERIAL# PROCESS SERVER SPID PID P_SERIAL# C50
---------- ---------- ------------------------ --------- ------ ------- ---------- --------------------------------------------------
60 21 51655 DEDICATED 51656 195 1 alter system kill session '60,21' immediate;
SCOTT@book> @ 10046on 8
Session altered.
SCOTT@book> select x from t where x =170 for update ;
--//挂起!!等待结束。
X
----------
170
SCOTT@book> @10046off
Session altered.
SCOTT@book> @ xid
XIDUSN_XIDSLOT_XIDSQN
------------------------------
68.21.16
--//对应16进制是0x0044.015.00000010
--//观察跟踪文件:
$ grep "WAIT.*TX" /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_51656.trc
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1001112 name|mode=1415053316 usn<<16 | slot=1900563 sequence=18 obj#=331601 tim=1646009349046308
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1000919 name|mode=1415053316 usn<<16 | slot=11665439 sequence=19 obj#=331601 tim=1646009350047337
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1000951 name|mode=1415053316 usn<<16 | slot=1966103 sequence=17 obj#=331601 tim=1646009351048375
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1000814 name|mode=1415053316 usn<<16 | slot=6619164 sequence=16 obj#=331601 tim=1646009352049278
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1000992 name|mode=1415053316 usn<<16 | slot=9764879 sequence=17 obj#=331601 tim=1646009353050390
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1000752 name|mode=1415053316 usn<<16 | slot=4587537 sequence=18 obj#=331601 tim=1646009354051241
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1001041 name|mode=1415053316 usn<<16 | slot=6946825 sequence=17 obj#=331601 tim=1646009355052378
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1000757 name|mode=1415053316 usn<<16 | slot=12124181 sequence=19 obj#=331601 tim=1646009356053225
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1000891 name|mode=1415053316 usn<<16 | slot=5373980 sequence=17 obj#=331601 tim=1646009357054247
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1000920 name|mode=1415053316 usn<<16 | slot=9633805 sequence=19 obj#=331601 tim=1646009358055257
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1000894 name|mode=1415053316 usn<<16 | slot=720926 sequence=3218 obj#=331601 tim=1646009359056243
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1000908 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646009360057244
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2000869 name|mode=1415053316 usn<<16 | slot=1900563 sequence=18 obj#=331601 tim=1646009362058240
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2001151 name|mode=1415053316 usn<<16 | slot=11665439 sequence=19 obj#=331601 tim=1646009364059481
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2000620 name|mode=1415053316 usn<<16 | slot=1966103 sequence=17 obj#=331601 tim=1646009366060191
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2001026 name|mode=1415053316 usn<<16 | slot=6619164 sequence=16 obj#=331601 tim=1646009368061324
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2000776 name|mode=1415053316 usn<<16 | slot=9764879 sequence=17 obj#=331601 tim=1646009370062232
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2000903 name|mode=1415053316 usn<<16 | slot=4587537 sequence=18 obj#=331601 tim=1646009372063256
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2000954 name|mode=1415053316 usn<<16 | slot=6946825 sequence=17 obj#=331601 tim=1646009374064326
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2000872 name|mode=1415053316 usn<<16 | slot=12124181 sequence=19 obj#=331601 tim=1646009376065331
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2000801 name|mode=1415053316 usn<<16 | slot=5373980 sequence=17 obj#=331601 tim=1646009378066263
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2000842 name|mode=1415053316 usn<<16 | slot=9633805 sequence=19 obj#=331601 tim=1646009380067206
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2001099 name|mode=1415053316 usn<<16 | slot=720926 sequence=3218 obj#=331601 tim=1646009382068420
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2000769 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646009384069277
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 4002028 name|mode=1415053316 usn<<16 | slot=1900563 sequence=18 obj#=331601 tim=1646009388071418
--//观察最后1个ITL槽的情况。单独检索slot=9699359.
$ grep "WAIT.*TX" /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_51656.trc | grep slot=9699359
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1000908 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646009360057244
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 2000769 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646009384069277
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 4001984 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646009432093269
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 8002922 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646009495413338
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 16005839 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646009566712352
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 32010527 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646009653988243
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 64001553 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646009773352234
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 128002159 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646009956764292
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 256007845 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646010268113364
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 512010697 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646010835514244
WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1337949215 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646012228784060
--//你可以发现一个特点.12个ITL槽为1组,开始1秒,然后2秒,然后4秒,然后5秒,最后1个ITL等待秒数是 2^(迭代次数-1).再然后还是5秒,最后1个ITL等待秒数是 2^(迭代次数-1),如此循环.
--//结束测试,注意最后1次不是2^10=102秒。
--//1415053316 = 0x54580004
--//5458 = TX
--//看看那些会话:
$ cat /tmp/itl.txt | awk '/ITL/{print $1}' | diff <(cut -c4- ) <(seq 169)
--//这次测试顺序一致,看看使用那些ITL槽。
SCOTT@book> @wcy trunc(sysdate)+08/24+46/1440+37/86400 sysdate "event='enq: TX - allocate ITL entry'"
-- Display ASH Wait Chain Signatures script v0.6 BETA by Tanel Poder ( http://blog.tanelpoder.com )
%This SECONDS AAS #Blkrs WAIT_CHAIN FIRST_SEEN LAST_SEEN
------ ---------- ---------- ------ ----------------------------------------------------------------------------- ------------------- -------------------
82% 2359 .6 1 -> 258,7,@1=>60,21,@1=>enq: TX - allocate ITL entry -> [idle blocker 1,258,7] 2022-02-28 08:49:19 2022-02-28 09:37:08
2% 47 0 1 -> 88,11,@1=>60,21,@1=>enq: TX - allocate ITL entry -> [idle blocker 1,88,11] 2022-02-28 08:49:10 2022-02-28 09:14:10
2% 47 0 1 -> 54,19,@1=>60,21,@1=>enq: TX - allocate ITL entry -> [idle blocker 1,54,19] 2022-02-28 08:49:08 2022-02-28 09:14:00
2% 47 0 1 -> 173,7,@1=>60,21,@1=>enq: TX - allocate ITL entry -> [idle blocker 1,173,7] 2022-02-28 08:49:14 2022-02-28 09:14:30
2% 47 0 1 -> 38,1,@1=>60,21,@1=>enq: TX - allocate ITL entry -> [idle blocker 1,38,1] 2022-02-28 08:49:09 2022-02-28 09:14:05
2% 47 0 1 -> 224,7,@1=>60,21,@1=>enq: TX - allocate ITL entry -> [idle blocker 1,224,7] 2022-02-28 08:49:18 2022-02-28 09:14:50
2% 47 0 1 -> 123,9,@1=>60,21,@1=>enq: TX - allocate ITL entry -> [idle blocker 1,123,9] 2022-02-28 08:49:12 2022-02-28 09:14:20
2% 47 0 1 -> 139,7,@1=>60,21,@1=>enq: TX - allocate ITL entry -> [idle blocker 1,139,7] 2022-02-28 08:49:15 2022-02-28 09:14:35
2% 47 0 1 -> 156,7,@1=>60,21,@1=>enq: TX - allocate ITL entry -> [idle blocker 1,156,7] 2022-02-28 08:49:13 2022-02-28 09:14:25
2% 47 0 1 -> 190,7,@1=>60,21,@1=>enq: TX - allocate ITL entry -> [idle blocker 1,190,7] 2022-02-28 08:49:16 2022-02-28 09:14:40
2% 47 0 1 -> 207,7,@1=>60,21,@1=>enq: TX - allocate ITL entry -> [idle blocker 1,207,7] 2022-02-28 08:49:17 2022-02-28 09:14:45
2% 47 0 1 -> 71,13,@1=>60,21,@1=>enq: TX - allocate ITL entry -> [idle blocker 1,71,13] 2022-02-28 08:49:11 2022-02-28 09:14:15
12 rows selected.
--//其它都是47秒。仅仅1个等待2359秒(也就是最后12ITL槽的最后1个ITL槽)。
WITH itl
AS ( SELECT TO_CHAR (sample_time, 'yyyy-mm-dd hh24:mi:ss') ss
,blocking_session
,blocking_session_serial#
FROM V$ACTIVE_SESSION_HISTORY
WHERE event = 'enq: TX - allocate ITL entry'
AND sample_time >= timestamp'2022-02-28 08:46:37'
ORDER BY sample_time)
SELECT blocking_session, blocking_session_serial#, COUNT (*)
FROM itl
GROUP BY blocking_session, blocking_session_serial#
ORDER BY 3;
BLOCKING_SESSION BLOCKING_SESSION_SERIAL# COUNT(*)
---------------- ------------------------ ----------
139 7 47
190 7 47
54 19 47
173 7 47
38 1 47
71 13 47
123 9 47
156 7 47
224 7 47
207 7 47
88 11 47
258 7 2359
12 rows selected.
--//你可以发现使用12个槽是固定的.
--//47+47+47+47+47+47+47+47+47+47+47+2359 = 2876,接近3000秒。
SELECT sample_time c30,blocking_session, blocking_session_serial#
FROM V$ACTIVE_SESSION_HISTORY
WHERE event = 'enq: TX - allocate ITL entry'
AND sample_time >= timestamp'2022-02-28 08:46:37'
ORDER BY sample_time;
C30 BLOCKING_SESSION BLOCKING_SESSION_SERIAL#
------------------------------ ---------------- ------------------------
2022-02-28 08:49:08.285 54 19
2022-02-28 08:49:09.285 38 1
2022-02-28 08:49:10.285 88 11
2022-02-28 08:49:11.285 71 13
2022-02-28 08:49:12.295 123 9
2022-02-28 08:49:13.295 156 7
2022-02-28 08:49:14.295 173 7
2022-02-28 08:49:15.295 139 7
2022-02-28 08:49:16.295 190 7
2022-02-28 08:49:17.295 207 7
2022-02-28 08:49:18.295 224 7
2022-02-28 08:49:19.305 258 7
2022-02-28 08:49:20.305 54 19
2022-02-28 08:49:21.305 54 19
2022-02-28 08:49:22.305 38 1
2022-02-28 08:49:23.305 38 1
2022-02-28 08:49:24.305 88 11
2022-02-28 08:49:25.305 88 11
2022-02-28 08:49:26.305 71 13
2022-02-28 08:49:27.305 71 13
2022-02-28 08:49:28.305 123 9
2022-02-28 08:49:29.332 123 9
2022-02-28 08:49:30.332 156 7
2022-02-28 08:49:31.342 156 7
2022-02-28 08:49:32.342 173 7
2022-02-28 08:49:33.342 173 7
2022-02-28 08:49:34.352 139 7
2022-02-28 08:49:35.352 139 7
2022-02-28 08:49:36.352 190 7
2022-02-28 08:49:37.352 190 7
2022-02-28 08:49:38.352 207 7
2022-02-28 08:49:39.352 207 7
2022-02-28 08:49:40.352 224 7
2022-02-28 08:49:41.352 224 7
2022-02-28 08:49:42.352 258 7
2022-02-28 08:49:43.352 258 7
2022-02-28 08:49:44.352 54 19
2022-02-28 08:49:45.352 54 19
2022-02-28 08:49:46.362 54 19
2022-02-28 08:49:47.362 54 19
....
...
--//监测会话sid = 54,38,88,71,123,156,173,139,190,207,224,258对应的ITL槽. 最后是258.
--//^54$|^38$|^88$|^71$|^123$|^156$|^173$|^139$|^190$|^207$|^224$|^258$
$ awk '/ITL/{print $2}' /tmp/itl.txt | egrep -n "^54$|^38$|^88$|^71$|^123$|^156$|^173$|^139$|^190$|^207$|^224$|^258$"
26:54
27:38
28:88
29:71
30:123
31:156
32:173
33:139
34:190
35:207
36:224
37:258
--//选择其中1段ITL槽,不知道算法。
--//这样http://antognini.ch/2011/04/itl-waits-changes-in-recent-releases/提供的伪码还是正确的,只不过itl.FIRST..itl.LAST
--//最多选择12个ITL槽.
iteration = 0
LOOP
iteration++
FOR i IN itl.FIRST..itl.LAST
LOOP
EXIT WHEN itl(i) IS FREE
IF i <> itl.LAST THEN
WAIT ON itl(i) FOR min(power(2,iteration-1),5) SECONDS
ELSIF iteration <= 10 THEN
WAIT ON itl(i) FOR power(2,iteration-1) SECONDS
ELSE
WAIT ON itl(i) FOREVER
END IF
END LOOP
EXIT WHEN free_itl_found
END LOOP
--//按照这个计算,迭代10次需要
--//12*1+12*2+12*4 = 84
--//11*5*7 = 385
--//8+16+32+64+128+256+512 = 1016
--//84+385+1016 = 1485
--//需要1485秒,也就是经过1485/60 = 24.75分钟,在最后1个ITL槽上无限等待它的释放.
--//经过1485+1024 = 2509 秒基本可以缺点算法。
--//附上wcy.sql脚本。
$ cat wcy.sql
@ tpt/ash/ash_wait_chains BLOCKING_SESSION||','||BLOCKING_SESSION_SERIAL#||',@'||BLOCKING_INST_ID||'=>'||session_id||','||SESSION_SERIAL#||',@'||inst_id||'=>'||event "&&3" &&1 &&2
--//补充:
select length(y), dbms_rowid.rowid_block_number(rowid) blk, count(*), min(x), max(x) from t
2 group by length(y), dbms_rowid.rowid_block_number(rowid);
LENGTH(Y) BLK COUNT(*) MIN(X) MAX(X)
---------- ---------- ---------- ---------- ----------
10 2524 171 1 171
SCOTT@book> alter system checkpoint ;
System altered.
SCOTT@book> alter system dump datafile 4 block 2524 ;
System altered.
Block header dump: 0x010009dc
Object id on Block? Y
seg/obj: 0x50f51 csc: 0x03.1ee0cbff itc: 169 flg: E typ: 1 - DATA
brn: 0 bdba: 0x10009d8 ver: 0x01 opc: 0
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x005e.01f.0000000f 0x00c00f99.0010.0d --U- 1 fsc 0x0000.1ee0ce0e
0x02 0x0044.015.00000010 0x00c00f71.001e.13 ---- 1 fsc 0x0000.00000000
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
0x03 0x00a3.011.00000011 0x00c006fa.001b.0a C--- 0 scn 0x0003.1ee0cb6d
0x04 0x00b6.012.00000012 0x00c00766.0022.1b C--- 0 scn 0x0003.1ee0cb71
0x05 0x003c.018.00000014 0x00c00ef5.0043.31 C--- 0 scn 0x0003.1ee0cb75
0x06 0x002d.019.00000013 0x00c014ea.002e.03 C--- 0 scn 0x0003.1ee0cb79
0x07 0x000f.00a.00000014 0x00c01515.002a.14 C--- 0 scn 0x0003.1ee0cb7d
0x08 0x0017.002.00000011 0x00c01de9.001e.14 C--- 0 scn 0x0003.1ee0cb81
0x09 0x001f.014.00000011 0x00c00ccb.0016.08 C--- 0 scn 0x0003.1ee0cb85
0x0a 0x0037.01d.00000013 0x00c016f1.002a.0f C--- 0 scn 0x0003.1ee0cb89
0x0b 0x006c.01b.00000011 0x00c00be1.0010.15 C--- 0 scn 0x0003.1ee0cb8e
0x0c 0x0023.01f.0000000f 0x00c00d62.0020.09 C--- 0 scn 0x0003.1ee0cb92
0x0d 0x00b0.017.00000013 0x00c00701.0024.0b C--- 0 scn 0x0003.1ee0cb96
0x0e 0x0097.00d.00000011 0x00c003f6.0018.11 C--- 0 scn 0x0003.1ee0cb9a
0x0f 0x00b4.017.00000012 0x00c023ce.002b.0d C--- 0 scn 0x0003.1ee0cb9e
0x10 0x0079.00f.00000012 0x00c00212.001b.0a C--- 0 scn 0x0003.1ee0cba2
0x11 0x000c.012.00000013 0x00c00b10.0021.0b C--- 0 scn 0x0003.1ee0cba6
0x12 0x00a7.00a.00000011 0x00c00675.000f.0e C--- 0 scn 0x0003.1ee0cbab
0x13 0x0036.020.00000012 0x00c00e94.002d.1e C--- 0 scn 0x0003.1ee0cbaf
0x14 0x0018.016.00000011 0x00c00b29.000f.0b C--- 0 scn 0x0003.1ee0cbb3
0x15 0x0071.005.00000012 0x00c000dd.001c.0a C--- 0 scn 0x0003.1ee0cbb7
0x16 0x0070.00f.00000012 0x00c0097c.0020.10 C--- 0 scn 0x0003.1ee0cbbb
0x17 0x003f.005.00000010 0x00c00f25.0013.0d C--- 0 scn 0x0003.1ee0cbbf
0x18 0x00a0.021.0000000f 0x00c01500.0011.19 C--- 0 scn 0x0003.1ee0cbc3
0x19 0x0006.00f.000033c4 0x00c000d4.0862.11 C--- 0 scn 0x0003.1ee0cbc7
0x1a 0x00c4.011.00000014 0x00c008ca.002b.26 C--- 0 scn 0x0003.1ee0cbcb
0x1b 0x001d.013.00000012 0x00c014b9.001a.14 C--- 0 scn 0x0003.1ee0cbcf
0x1c 0x00b2.01f.00000013 0x00c01549.0028.10 C--- 0 scn 0x0003.1ee0cbd3
0x1d 0x001e.017.00000011 0x00c00d1f.0012.0e C--- 0 scn 0x0003.1ee0cbd7
0x1e 0x0065.01c.00000010 0x00c01186.0012.0a C--- 0 scn 0x0003.1ee0cbdb
0x1f 0x0095.00f.00000011 0x00c00b6f.000b.12 C--- 0 scn 0x0003.1ee0cbdf
0x20 0x0046.011.00000012 0x00c00f94.0025.10 C--- 0 scn 0x0003.1ee0cbe4
0x21 0x006a.009.00000011 0x00c011d7.000e.0a C--- 0 scn 0x0003.1ee0cbe8
0x22 0x00b9.015.00000013 0x00c00817.0025.07 C--- 0 scn 0x0003.1ee0cbec
0x23 0x0052.01c.00000011 0x00c006e8.0027.0d C--- 0 scn 0x0003.1ee0cbf0
0x24 0x0093.00d.00000013 0x00c00ecd.0025.17 C--- 0 scn 0x0003.1ee0cbf4
0x25 0x000b.01e.00000c92 0x00c000ee.031d.0d C--- 0 scn 0x0003.1ee0cbf8
0x26 0x0094.01f.00000012 0x00c00428.0022.07 C--- 0 scn 0x0003.1ee0cbfc
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
0x27 0x0027.01f.00000011 0x00c00da4.001b.12 --U- 1 fsc 0x0000.1ee0cc00
0x28 0x009a.00a.00000011 0x00c01a13.0020.0f --U- 1 fsc 0x0000.1ee0cc04
0x29 0x0072.004.00000012 0x00c0014c.0019.0b --U- 1 fsc 0x0000.1ee0cc08
0x2a 0x004b.021.00000014 0x00c00fe1.0036.1e --U- 1 fsc 0x0000.1ee0cc0c
0x2b 0x0020.003.00000010 0x00c0150f.000d.0a --U- 1 fsc 0x0000.1ee0cc10
0x2c 0x00b3.015.00000011 0x00c00736.000d.0d --U- 1 fsc 0x0000.1ee0cc14
0x2d 0x0078.00b.00000011 0x00c00205.001e.11 --U- 1 fsc 0x0000.1ee0cc18
0x2e 0x008e.003.00000011 0x00c00365.000c.06 --U- 1 fsc 0x0000.1ee0cc1c
0x2f 0x00ab.010.00000013 0x00c015f5.0021.10 --U- 1 fsc 0x0000.1ee0cc20
0x30 0x002c.009.00000012 0x00c00df3.0019.12 --U- 1 fsc 0x0000.1ee0cc24
0x31 0x001c.018.00000011 0x00c00cf6.0031.0e --U- 1 fsc 0x0000.1ee0cc28
0x32 0x000d.01d.00000014 0x00c0017c.0021.11 --U- 1 fsc 0x0000.1ee0cc2c
0x33 0x0074.009.00000011 0x00c01245.001a.0e --U- 1 fsc 0x0000.1ee0cc30
0x34 0x0076.013.00000013 0x00c01266.0022.0d --U- 1 fsc 0x0000.1ee0cc34
0x35 0x0033.01c.00000011 0x00c00e63.002c.0c --U- 1 fsc 0x0000.1ee0cc38
0x36 0x00a5.018.00000014 0x00c01229.0048.0d --U- 1 fsc 0x0000.1ee0cc3c
0x37 0x0008.009.0000352f 0x00c000f1.08d9.0f --U- 1 fsc 0x0000.1ee0cc40
0x38 0x00ba.020.00000012 0x00c01b40.001d.0e --U- 1 fsc 0x0000.1ee0cc44
0x39 0x0081.000.00000010 0x00c00293.0017.18 --U- 1 fsc 0x0000.1ee0cc48
0x3a 0x005f.01c.0000000f 0x00c00c59.0012.0f --U- 1 fsc 0x0000.1ee0cc4c
0x3b 0x0075.01d.00000011 0x00c01257.001a.17 --U- 1 fsc 0x0000.1ee0cc50
0x3c 0x007b.000.00000013 0x00c00232.001f.20 --U- 1 fsc 0x0000.1ee0cc54
0x3d 0x0085.003.00000013 0x00c0031a.0029.0c --U- 1 fsc 0x0000.1ee0cc58
0x3e 0x0055.008.00000012 0x00c01086.0017.13 --U- 1 fsc 0x0000.1ee0cc5c
0x3f 0x0030.01d.00000011 0x00c0112c.0029.0d --U- 1 fsc 0x0000.1ee0cc60
0x40 0x0084.00d.00000012 0x00c002c4.001f.0d --U- 1 fsc 0x0000.1ee0cc64
0x41 0x00aa.014.00000012 0x00c006a8.001b.0c --U- 1 fsc 0x0000.1ee0cc68
0x42 0x0014.01f.00000013 0x00c004c9.001a.11 --U- 1 fsc 0x0000.1ee0cc6c
0x43 0x0062.00c.00000011 0x00c01dab.0019.16 --U- 1 fsc 0x0000.1ee0cc70
0x44 0x0040.01e.0000000f 0x00c00f35.0013.14 --U- 1 fsc 0x0000.1ee0cc74
0x45 0x0011.004.00000016 0x00c004c6.0036.15 --U- 1 fsc 0x0000.1ee0cc78
0x46 0x000e.020.00000014 0x00c00492.0021.15 --U- 1 fsc 0x0000.1ee0cc7c
0x47 0x0043.018.00000011 0x00c00f67.0022.0d --U- 1 fsc 0x0000.1ee0cc80
0x48 0x0024.005.00000010 0x00c00d77.0012.0b --U- 1 fsc 0x0000.1ee0cc84
0x49 0x005b.01a.00000012 0x00c010e3.001b.11 --U- 1 fsc 0x0000.1ee0cc88
0x4a 0x0086.001.00000013 0x00c002e4.001b.0e --U- 1 fsc 0x0000.1ee0cc8c
0x4b 0x00a8.01b.00000013 0x00c01309.0026.1c --U- 1 fsc 0x0000.1ee0cc90
0x4c 0x001b.005.00000012 0x00c01dc5.001b.0e --U- 1 fsc 0x0000.1ee0cc94
0x4d 0x004c.020.00000013 0x00c00ff3.002f.12 --U- 1 fsc 0x0000.1ee0cc98
0x4e 0x0073.009.00000011 0x00c013c8.000e.0f --U- 1 fsc 0x0000.1ee0cc9c
0x4f 0x0053.013.00000013 0x00c01061.0022.17 --U- 1 fsc 0x0000.1ee0cca0
0x50 0x0004.00f.00003248 0x00c01ca8.0776.12 --U- 1 fsc 0x0000.1ee0cca4
0x51 0x0041.012.0000000f 0x00c00f4e.000e.09 --U- 1 fsc 0x0000.1ee0cca8
0x52 0x0054.017.00000012 0x00c00afb.0041.03 --U- 1 fsc 0x0000.1ee0ccac
0x53 0x007a.020.00000010 0x00c00223.0034.0d --U- 1 fsc 0x0000.1ee0ccb0
0x54 0x005c.011.00000011 0x00c01603.000d.04 --U- 1 fsc 0x0000.1ee0ccb4
0x55 0x008c.009.00000012 0x00c00345.0015.0d --U- 1 fsc 0x0000.1ee0ccb8
0x56 0x0001.00e.0000325d 0x00c00c2a.08a1.0e --U- 1 fsc 0x0000.1ee0ccbc
0x57 0x006d.000.00000012 0x00c0203c.0019.0e --U- 1 fsc 0x0000.1ee0ccc0
0x58 0x0021.005.0000000f 0x00c00d49.0024.10 --U- 1 fsc 0x0000.1ee0ccc4
0x59 0x00c1.009.00000012 0x00c00896.002a.10 --U- 1 fsc 0x0000.1ee0ccc8
0x5a 0x0034.01e.00000012 0x00c00e79.0021.15 --U- 1 fsc 0x0000.1ee0cccc
0x5b 0x00c3.00d.00000011 0x00c01b03.0015.15 --U- 1 fsc 0x0000.1ee0ccd0
0x5c 0x0089.013.00000012 0x00c0035d.001a.13 --U- 1 fsc 0x0000.1ee0ccd4
0x5d 0x00af.01b.00000012 0x00c006f4.0020.0a --U- 1 fsc 0x0000.1ee0ccd8
0x5e 0x004e.008.00000012 0x00c00a47.001a.1a --U- 1 fsc 0x0000.1ee0ccdc
0x5f 0x0035.015.00000012 0x00c00e8c.0020.0c --U- 1 fsc 0x0000.1ee0cce0
0x60 0x0051.016.00000011 0x00c01045.0015.0a --U- 1 fsc 0x0000.1ee0cce4
0x61 0x0090.01c.00000012 0x00c00387.0023.06 --U- 1 fsc 0x0000.1ee0cce8
0x62 0x0042.014.0000000f 0x00c00f54.0024.0b --U- 1 fsc 0x0000.1ee0ccec
0x63 0x00a4.015.00000011 0x00c00647.0010.0b --U- 1 fsc 0x0000.1ee0ccf0
0x64 0x00a2.001.00000010 0x00c0155f.000d.04 --U- 1 fsc 0x0000.1ee0ccf4
0x65 0x0067.01c.00000012 0x00c00889.001c.0f --U- 1 fsc 0x0000.1ee0ccf8
0x66 0x00b8.007.00000012 0x00c01712.001a.0e --U- 1 fsc 0x0000.1ee0ccfc
0x67 0x00c0.00a.00000010 0x00c012f0.0019.03 --U- 1 fsc 0x0000.1ee0cd00
0x68 0x006f.00a.00000013 0x00c00a11.0029.1f --U- 1 fsc 0x0000.1ee0cd04
0x69 0x0022.006.00000011 0x00c00d58.0023.15 --U- 1 fsc 0x0000.1ee0cd08
0x6a 0x00bb.01f.00000010 0x00c00e2d.001f.13 --U- 1 fsc 0x0000.1ee0cd0c
0x6b 0x0032.020.00000011 0x00c00e51.0023.0b --U- 1 fsc 0x0000.1ee0cd10
0x6c 0x009b.01e.00000011 0x00c00433.0010.0a --U- 1 fsc 0x0000.1ee0cd14
0x6d 0x0057.00a.00000011 0x00c010a6.0011.0a --U- 1 fsc 0x0000.1ee0cd18
0x6e 0x0002.009.000033a4 0x00c00097.06a1.05 --U- 1 fsc 0x0000.1ee0cd1c
0x6f 0x0003.00a.0000332a 0x00c001d2.0928.0e --U- 1 fsc 0x0000.1ee0cd20
0x70 0x0064.018.0000000f 0x00c01176.0008.07 --U- 1 fsc 0x0000.1ee0cd24
0x71 0x008a.003.00000012 0x00c00326.0021.06 --U- 1 fsc 0x0000.1ee0cd28
0x72 0x0005.019.00003309 0x00c005a8.08fb.0c --U- 1 fsc 0x0000.1ee0cd2c
0x73 0x008b.018.00000012 0x00c00a2b.001b.0a --U- 1 fsc 0x0000.1ee0cd30
0x74 0x0016.004.00000012 0x00c0085b.0014.05 --U- 1 fsc 0x0000.1ee0cd34
0x75 0x0068.014.00000011 0x00c011b4.001e.0b --U- 1 fsc 0x0000.1ee0cd38
0x76 0x00a1.01d.00000012 0x00c00617.0021.0a --U- 1 fsc 0x0000.1ee0cd3c
0x77 0x006e.015.00000012 0x00c00379.0015.09 --U- 1 fsc 0x0000.1ee0cd40
0x78 0x003b.00b.00000012 0x00c00ee5.0020.07 --U- 1 fsc 0x0000.1ee0cd44
0x79 0x007c.019.00000012 0x00c0034a.001a.14 --U- 1 fsc 0x0000.1ee0cd48
0x7a 0x0013.016.00000014 0x00c013e9.0024.0b --U- 1 fsc 0x0000.1ee0cd4c
0x7b 0x0050.00d.00000013 0x00c01924.003e.1b --U- 1 fsc 0x0000.1ee0cd50
0x7c 0x00a6.019.00000011 0x00c0117e.001a.0c --U- 1 fsc 0x0000.1ee0cd54
0x7d 0x0048.020.00000012 0x00c0033a.001c.35 --U- 1 fsc 0x0000.1ee0cd58
0x7e 0x0092.013.00000012 0x00c00818.0022.1e --U- 1 fsc 0x0000.1ee0cd5c
0x7f 0x0087.01c.00000010 0x00c002f2.0014.0d --U- 1 fsc 0x0000.1ee0cd60
0x80 0x00ac.018.00000012 0x00c008ad.001e.08 --U- 1 fsc 0x0000.1ee0cd64
0x81 0x0088.020.00000011 0x00c006da.001a.19 --U- 1 fsc 0x0000.1ee0cd68
0x82 0x0049.00f.00000013 0x00c00fc4.0026.08 --U- 1 fsc 0x0000.1ee0cd6c
0x83 0x00b1.010.00000011 0x00c02345.0010.1c --U- 1 fsc 0x0000.1ee0cd70
0x84 0x0066.016.00000011 0x00c00b72.0014.0e --U- 1 fsc 0x0000.1ee0cd74
0x85 0x003d.01f.00000013 0x00c00f08.002e.08 --U- 1 fsc 0x0000.1ee0cd78
0x86 0x003a.001.00000012 0x00c00ed3.0024.11 --U- 1 fsc 0x0000.1ee0cd7c
0x87 0x004d.01f.00000011 0x00c0100f.0017.16 --U- 1 fsc 0x0000.1ee0cd80
0x88 0x005d.000.00000012 0x00c01101.0020.11 --U- 1 fsc 0x0000.1ee0cd84
0x89 0x0012.01f.00000014 0x00c00768.0026.0b --U- 1 fsc 0x0000.1ee0cd88
0x8a 0x0045.01e.00000010 0x00c00c3b.001b.0d --U- 1 fsc 0x0000.1ee0cd8c
0x8b 0x0082.017.0000000f 0x00c002a1.0013.13 --U- 1 fsc 0x0000.1ee0cd90
0x8c 0x0077.00c.00000012 0x00c010fb.0022.10 --U- 1 fsc 0x0000.1ee0cd94
0x8d 0x0026.00d.00000011 0x00c00d97.001b.13 --U- 1 fsc 0x0000.1ee0cd98
0x8e 0x008d.006.00000013 0x00c002ce.0021.0c --U- 1 fsc 0x0000.1ee0cd9c
0x8f 0x0069.014.00000011 0x00c0149d.001b.13 --U- 1 fsc 0x0000.1ee0cda0
0x90 0x00bd.01d.00000013 0x00c00857.003e.0f --U- 1 fsc 0x0000.1ee0cda4
0x91 0x002a.018.00000010 0x00c00a76.001b.05 --U- 1 fsc 0x0000.1ee0cda8
0x92 0x004f.00b.00000012 0x00c0080b.0018.12 --U- 1 fsc 0x0000.1ee0cdac
0x93 0x003e.003.00000013 0x00c00f11.002b.13 --U- 1 fsc 0x0000.1ee0cdb0
0x94 0x000a.00c.0003dd04 0x00c000ae.23c0.15 --U- 1 fsc 0x0000.1ee0cdb4
0x95 0x0047.011.00000013 0x00c00fa3.002f.1a --U- 1 fsc 0x0000.1ee0cdb8
0x96 0x004a.010.00000013 0x00c01364.0024.10 --U- 1 fsc 0x0000.1ee0cdbc
0x97 0x009e.017.00000010 0x00c011e8.0028.0b --U- 1 fsc 0x0000.1ee0cdc0
0x98 0x00bf.015.0000000f 0x00c00875.0015.0e --U- 1 fsc 0x0000.1ee0cdc4
0x99 0x0099.011.00000011 0x00c0020c.002f.11 --U- 1 fsc 0x0000.1ee0cdc8
0x9a 0x00b5.01b.00000014 0x00c00754.0027.10 --U- 1 fsc 0x0000.1ee0cdcc
0x9b 0x0019.017.00000012 0x00c00154.001d.1b --U- 1 fsc 0x0000.1ee0cdd1
0x9c 0x0029.011.00000015 0x00c00dc4.0030.15 --U- 1 fsc 0x0000.1ee0cdd5
0x9d 0x00ae.005.00000012 0x00c00c4a.001f.12 --U- 1 fsc 0x0000.1ee0cdd9
0x9e 0x0009.004.00008fac 0x00c00106.0b7d.0d --U- 1 fsc 0x0000.1ee0cddd
0x9f 0x00c2.00e.00000012 0x00c00cdd.0021.0b --U- 1 fsc 0x0000.1ee0cde1
0xa0 0x0028.01f.00000012 0x00c00db3.0023.25 --U- 1 fsc 0x0000.1ee0cde5
0xa1 0x002b.00f.00000011 0x00c00de4.0013.1c --U- 1 fsc 0x0000.1ee0cde9
0xa2 0x005a.00a.00000012 0x00c00bb2.0016.0e --U- 1 fsc 0x0000.1ee0cded
0xa3 0x0010.000.00000014 0x00c004b1.0012.16 --U- 1 fsc 0x0000.1ee0cdf1
0xa4 0x0015.006.00000014 0x00c02249.0028.14 --U- 1 fsc 0x0000.1ee0cdf5
0xa5 0x00a9.002.00000014 0x00c00695.0021.0e --U- 1 fsc 0x0000.1ee0cdf9
0xa6 0x009c.01a.0000000f 0x00c01344.0011.16 --U- 1 fsc 0x0000.1ee0cdfd
0xa7 0x007d.00c.00000010 0x00c00a4e.0018.0b --U- 1 fsc 0x0000.1ee0ce01
0xa8 0x008f.002.00000013 0x00c0028f.0023.16 --U- 1 fsc 0x0000.1ee0ce05
0xa9 0x0091.011.00000013 0x00c00394.0030.0e --U- 1 fsc 0x0000.1ee0ce0a
bdba: 0x010009dc
data_block_dump,data header at 0x7fa89675f20c
===============
tsiz: 0xff0
hsiz: 0x168
pbl: 0x7fa89675f20c
76543210
flag=--------
ntab=1
nrow=171
frre=-1
fsbo=0x168
fseo=0x44e
avsp=0x2e6
tosp=0x2e6
--//WAIT #140362055751624: nam='enq: TX - allocate ITL entry' ela= 1000908 name|mode=1415053316 usn<<16 | slot=9699359 sequence=18 obj#=331601 tim=1646009360057244
--//9699359 = /2^16 %2^16 (Type | Mode) = 148,31 = 0x94001f
--//148 = 0x94 0x0094.01f
--//与下划线内容对上,也就是0x26槽。
--//有点奇怪的是实际上ITL=0x02来提交的,也就是等待0x26槽的释放后,在找一个合适的ITL槽执行事务。
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 实操Deepseek接入个人知识库
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
2019-02-28 [20190227]简单探究tab$的bojb#字段.txt