[20220303]oracle如何定位使用librarycachemutex3.txt
[20220303]oracle如何定位使用library cache mutex 3.txt
--//这个问题实际上困扰我很久，我开始以为library cache bucket在1个chunk内，只要知道 基地址+40*buckect值 获得偏移,定位
--//library cache bucket 的地址。
--//注：11g 下每个library cache bucket占用16字节，后面跟着mutex，mutex结构占用24字节(注:有朋友讲占用16字节,我想与转储看
--//到mutex仅仅有4个值有关,4*4=16，我个人还是按照24字节来算),这样整个结构占用40字节。
--//可以参考我前面的测试 [20210524]分析library cache转储 3.txt
--//而实际上的情况被分成好几个chunk，显然无法简单的通过 基地址+40*buckect值 计算获得偏移，那么oracle计算sql语句的
--//hash_value，通过hash_value值计算出bucket值, 等于hash_value % (2^_kgl_bucket_count * 256) ,知道bucket数值，
--//如何通过bucket数值来定位library cache muext的地址呢？自己尝试做这方面的探究。
--//测试_kghdsidx_count <> 1 的情况。
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
SYS@book> alter system set "_kghdsidx_count"=3 scope=spfile;
System altered.
SYS@book> @ hide _kgl_bucket_count
NAME DESCRIPTION DEFAULT_VALUE SESSION_VALUE SYSTEM_VALUE ISSES ISSYS_MOD
----------------- ------------------------------------------------------------------ ------------- ------------- ------------ ----- ---------
_kgl_bucket_count Library cache hash table bucket count (2^_kgl_bucket_count * 256) TRUE 9 9 FALSE FALSE
--//缺省2^9*256 = 131072.
--//重启数据库略.
SYS@book> @ hide _kghdsidx_count
NAME DESCRIPTION DEFAULT_VALUE SESSION_VALUE SYSTEM_VALUE ISSES ISSYS_MOD
--------------- ------------------ ------------- ------------- ------------ ----- ---------
_kghdsidx_count max kghdsidx count FALSE 3 3 FALSE FALSE
--//首先说明一下11g使用library cache mutex代替10g library cache latch,定位library cache mutex就很容易定位library cache
--//latch地址，仅仅偏移16字节。而且muext结构体里面记录了library cache latch值。
--//参考：http://blog.itpub.net/267265/viewspace-2792123/ =>[20210915]探究mutex的值 6.txt
2.建立测试环境：
create table t as select rownum id ,"test" pad from dual connect by level<=1e6;
alter table t add constraint pk_t primary key (id);
exec dbms_stats.gather_table_stats(user, "t", method_opt=>"for all columns size 1");
alter system flush shared_pool;
$ cat tt1.txt
declare
v_pad varchar2(10);
begin
for i in 1 .. 1e5 loop
execute immediate "select pad from t where id = " || i into v_pad;
end loop;
end;
/
@ tt1.txt
3.转储library_cache:
--//有了前面的探究，这次就简单许多。
SYS@book> oradebug setmypid
Statement processed.
SYS@book> oradebug dump library_cache 8
Statement processed.
SYS@book> @ ttt
tracefile_identifier = /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_18540.trc
$ grep "Bucket:" /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_18540.trc | sed "s/^Bucket: #=//;s/Mutex=//;s/(.*)//" >| d1.txt
--//将Bucket以及mutex地址写入文件d1.txt
$ awk "NR==1{a=$1;b=strtonum($2) } NR>1{ print (strtonum($2)-b)/($1-a);a=$1;b=strtonum($2)}" d1.txt | sort | uniq -c | sort -nr
2549 40
5 304257
4 -98694
4 -77020.7
4 -229966
4 223133
4 -116978
3 -80194.5
3 -67183.1
3 -59961.5
3 -51754.9
3 -48567.5
3 -405852
3 -32871.3
3 323884
3 303913
3 -287467
3 -275967
3 -265351
3 264229
3 -26289.1
3 -24643.5
3 239068
3 -191631
3 -175487
3 147675
3 127118
3 -126593
3 -125418
3 112840
3 -108908
2 -95795.7
2 -93205.5
2 -90751.7
2 -90231.1
2 -87759
2 -87723.6
2 -85351.6
2 84402.8
2 82328.3
2 -78947.2
2 -74961.8
2 -74788.7
2 -73436.5
2 -73366
2 -65782.7
2 -61910.7
2 607786
2 -59444.2
2 -58436
2 -50110.6
2 -47116.5
2 456366
2 -44459.8
2 -43841.8
2 -42086.5
2 418339
2 -41532.2
2 -40992.3
2 -39953.5
2 -36698.2
2 -34679.6
2 -33571.6
2 -32199.7
2 -31874
2 -313604
2 -30634.6
2 -30339.7
2 -30050.4
2 -29766.5
2 -29487.9
2 -28946.1
2 -287186
2 286874
2 -27920.1
2 -26510.3
2 -263251
2 257455
2 -255522
2 -242998
2 -23715.5
2 -23363.6
2 228203
2 213639
2 -205739
2 -197428
2 196887
2 193101
2 -186451
2 -18118
2 -168257
2 164852
2 -164583
2 -164250
2 159392
2 -153297
2 -149964
2 145535
2 -143573
2 141437
2 -132656
2 132134
2 123980
2 119554
2 -113078
2 -105276
2 -102948
2 102481
2 -101879
1 -99962.4
1 -99731.6
1 98463.3
1 -98242.5
1 97279.4
1 -97145.5
1 96570.5
1 -95702.1
1 95651.2
1 -95393.7
1 93539.4
1 -92886.1
1 908942
1 90483
1 -89572.6
1 -88423.7
1 88102.9
1 -87303.9
1 -862481
1 -82271.6
1 81753.7
1 -81255.4
1 80353.4
1 79716
1 -77490
1 -766645
1 -76628.5
1 -75786
1 -75648.8
1 -75185.9
1 74959.2
1 74404.3
1 73318.7
1 73152.3
1 -73125.9
1 72606.7
1 -72321.8
1 -71836.8
1 -71766.5
1 -71535.3
1 71239.8
1 -71095.8
1 70738.4
1 -70369.9
1 -70170.8
1 -69275
1 69004.1
1 -68961.7
1 -68644.5
1 -67845.9
1 -67608.7
1 67417
1 66967.8
1 -66951.9
1 66189.2
1 66087.2
1 -658453
1 -65809.3
1 -65675.9
1 65229.5
1 -64439.3
1 -63891.3
1 -63264.3
1 -63149.8
1 -631065
1 -62688.8
1 -62082
1 62010.2
1 -61568.6
1 61196.8
1 -61023.4
1 -60719.4
1 590580
1 58972.9
1 -58469
1 -580047
1 -574974
1 -56726.6
1 -56379.4
1 -56241.4
1 557772
1 -55161.3
1 -54433.9
1 54061.9
1 540259
1 -53867.6
1 53439.9
1 -51841
1 51763.1
1 51218.6
1 511826
1 51000.3
1 -50919.5
1 501999
1 49738.9
1 -49327
1 -492829
1 -49246.9
1 -48552.7
1 478096
1 -470312
1 -46582.8
1 4614464
1 -46008.4
1 -45961.1
1 -458416
1 -45749.7
1 -45095.5
1 44658.6
1 442037
1 -44154.1
1 44071.5
1 436526
1 -43086.1
1 -42655.8
1 42318
1 -41902.2
1 41595.3
1 -41374.6
1 -41115.8
1 -40789.4
1 405204
1 -40466.3
1 -40311.9
1 401607
1 -39389.5
1 -38966
1 -38725
1 -38490.3
1 -38082.5
1 38024.1
1 -376440
1 374038
1 -36276.7
1 -35863.3
1 358582
1 -35527.9
1 35514.1
1 347323
1 346218
1 -344968
1 -33951
1 -33933
1 -329206
1 -32532
1 -31758
1 31609.7
1 -315909
1 313715
1 -31242.1
1 -30935.4
1 -30764.3
1 -30357.2
1 277867
1 -27674.8
1 -27433.8
1 2.72675e+06
1 270149
1 -26964.2
1 26535.7
1 262849
1 -25421.9
1 251019
1 2509834
1 -246395
1 244898
1 -23732.3
1 -23022
1 226178
1 -225638
1 -22527.8
1 -22147
1 -219458
1 218283
1 -21749.6
1 -215590
1 -21307.9
1 -212377
1 -21023.3
1 -20883.8
1 -2.03026e+06
1 -202906
1 202622
1 2.00788e+06
1 -197108
1 -19706.8
1 -19463
1 -193634
1 -19225.2
1 -18993.1
1 189458
1 -18879.1
1 185951
1 -182875
1 176166
1 -17512.7
1 -17415.7
1 -16765.8
1 167360
1 -166249
1 -16330.4
1 161962
1 -16079.8
1 -160568
1 159449
1 154388
1 -15297.3
1 152149
1 -15149.8
1 -15005.2
1 -149617
1 -14519.9
1 145173
1 143457
1 1434208
1 -143111
1 143039
1 1.3951e+06
1 -13940
1 -13817.4
1 137563
1 136997
1 135705
1 -135257
1 -134346
1 -13404.6
1 133896
1 133245
1 -1.32202e+06
1 -131605
1 131445
1 130419
1 -130152
1 128747
1 -123177
1 -121479
1 -118928
1 118148
1 -117548
1 115433
1 114122
1 -113493
1 -11203.7
1 111809
1 -111569
1 1115504
1 -111253
1 109298
1 1.09072e+06
1 -107775
1 106840
1 105716
1 -104508
1 -10421.9
1 103537
1 102397
1 1.01888e+06
1 100287
--//可以发现40出现次数最多，说明一个chunk内每个mutex地址的间隔是40个字节，参考[20210524]分析library cache转储 3.txt 的测试。
--//出现1个很奇怪的现象，一种感觉怎么会使用这么多的chunk，这个好像有点问题。
$ awk "NR==1{a=$1;b=strtonum($2) } NR>1{ print (strtonum($2)-b)/($1-a);a=$1;b=strtonum($2)}" d1.txt | sort | uniq -c | sort -nr|wc
367 734 5928
--//为什么？我很久以前做探究时就遇到这个情况，当时想"_kghdsidx_count"=1的情况我都不清楚，这个问题就暂时先放一放。
--//现在有了前面的探究，感觉难度不是太大，自己再次尝试看看。
--//查询地址跳跃的情况，也就是间隔不是40的情况。
$ awk "NR==1{a=$1;b=strtonum($2);c=$2 } NR>1{ print a,c,$1,$2,(strtonum($2)-b)/($1-a);a=$1;b=strtonum($2);c=$2}" d1.txt | grep -v "40$" | head
229 0x8678c5e0 310 0x86145828 -81255.4
447 0x86146d90 543 0x85e446d0 -32871.3
664 0x85e459b8 783 0x8678cc70 81753.7
990 0x8678ecc8 1107 0x861484b0 -56241.4
1223 0x861496d0 1389 0x85e47b00 -18993.1
1514 0x85e48e88 1648 0x86790398 72606.7
1695 0x86790af0 1855 0x8614a990 -41115.8
2019 0x8614c330 2126 0x85e49e28 -29487.9
2286 0x85e4b728 2308 0x86791ab8 442037
2552 0x867940d8 2601 0x8614ce20 -134346
--//注：太长我使用head显示前10行。
--//取出第2个字段，通过awk保存aa4.txt：
$ awk "NR==1{a=$1;b=strtonum($2);c=$2 } NR>1{ print a,c,$1,$2,(strtonum($2)-b)/($1-a);a=$1;b=strtonum($2);c=$2}" d1.txt | grep -v "40$" | awk "{print "@fchaz " $2}" > aa4.txt
$ head -3 aa4.txt
@fchaz 0x8678c5e0
@fchaz 0x86146d90
@fchaz 0x85e459b8
--//注：fcha.sql脚本前面有prompt，pause命令，我不可能每次都按1次回车太浪费时间，我建立一个新的fchaz.sql脚本，删除这部分
--//内容,我自己还做了一点小改动，增加结束地址显示。
--//先不执行如上aa4.txt脚本，先确定bucket 0的地址看看。
$ head -1 d1.txt
16 0x8678a498
--//跟踪文件对应记录内容如下：
--//Bucket: #=16 Mutex=0x8678a498(0, 6, 0, 6)
--//16*40 = 640，该bucket的地址 0x8678a498 - 16 = 0x8678a488。
SYS@book> @ tpt/calc 0x8678a488 - 640
DEC HEX
----------------------------------- --------------------
2256052744.000000 8678A208
--//bucket 0 的地址 0x8678A208
SYS@book> @ fcha 0x8678A208
Find in which heap (UGA, PGA or Shared Pool) the memory address 0x8678A208 resides...
Press ENTER to continue, CTRL+C to cancel...
LOC KSMCHPTR KSMCHIDX KSMCHDUR KSMCHCOM KSMCHSIZ KSMCHCLS KSMCHTYP KSMCHPAR
--- ---------------- ---------- ---------- ---------------- ---------- -------- ---------- ----------------
SGA 0000000086434000 2 1 permanent memor 3979784 perm 0 00
--//如果你注意前面的测试，可以发现KSMCHIDX=2,前面的测试是KSMCHIDX=1。
SYS@book> @ tpt/calc x0000000086034000 + 3979784
DEC HEX
----------------------------------- --------------------
2252339720.000000 863FFA08
--//第一个chunk的范围是 0x86034000 - 0x863FFA08
SELECT rownum
, x$ksmmem.*
FROM X$KSMMEM
WHERE addr between hextoraw("0000000086034000") and hextoraw("00000000863FFA08")
AND ksmmmval = hextoraw("000000008678A208");
no rows selected
--//恩，没有输出。难道该表不在这个chunk中吗？
--//执行如下：
spool /tmp/fchaz.txt
@aa4.txt
spool off
$ sort /tmp/fchaz.txt | uniq -c
505
505 --- ---------------- ---------- ---------- ---------------- ---------- -------- ---------- ---------------- -----------------
505 LOC KSMCHPTR KSMCHIDX KSMCHDUR KSMCHCOM KSMCHSIZ KSMCHCLS KSMCHTYP KSMCHPAR KSMCHPTR_END
114 SGA 0000000085834000 2 1 permanent memor 3968008 perm 0 00 0000000085BFCC07
170 SGA 0000000085C34000 1 1 permanent memor 3937272 perm 0 00 0000000085FF53F7
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
169 SGA 0000000086034000 3 1 permanent memor 3979488 perm 0 00 00000000863FF8DF
47 SGA 0000000086434000 2 1 permanent memor 3979784 perm 0 00 00000000867FFA07
1 SGA 00000000877FCDF0 2 1 permanent memor 10272 perm 0 00 00000000877FF60F
4 SGA 00000000897F1800 2 1 permanent memor 51232 perm 0 00 00000000897FE01F
1 SYS@book> @ aa4.txt
1 SYS@book> spool off
--//从输出结果执行sort,uniq后发现看上去感觉chunk使用很多，自己上就是在6个chunk上跳来跳去。
--//根据前面测试最大可能在KSMCHIDX=1的chunk，也就是下划线的内容指向的chunk可能性最大，当然仅仅是我的猜测。
SELECT rownum
, x$ksmmem.*
FROM X$KSMMEM
WHERE addr between hextoraw("0000000085C34000") and hextoraw("0000000085FF53F7")
AND ksmmmval = hextoraw("000000008678A208");
ROWNUM ADDR INDX INST_ID KSMMMVAL
---------- ---------------- ---------- ---------- ----------------
1 0000000085E431E8 79463997 1 000000008678A208
--//先尝试推断该数组的开始地址是x85E431E8
--//2^9 = 512, 512*8 = 4096
SYS@book> @ tpt/calc x85E431E8 + 4096
DEC HEX
----------------------------------- --------------------
2246328808.000000 85E441E8
--//查询hextoraw("0000000085E431E8") and hextoraw("0000000085E441E0")范围的信息:
SELECT rownum-1 rn
, x$ksmmem.*
FROM X$KSMMEM
WHERE addr between hextoraw("0000000085E431E8") and hextoraw("0000000085E441E0");
RN ADDR INDX INST_ID KSMMMVAL
---- ---------------- -------- ------- ----------------
0 0000000085E431E8 79463997 1 000000008678A208
1 0000000085E431F0 79463998 1 0000000086144FA8
2 0000000085E431F8 79463999 1 0000000085E441E8
3 0000000085E43200 79464000 1 000000008678CA08
4 0000000085E43208 79464001 1 00000000861477A8
5 0000000085E43210 79464002 1 0000000085E469E8
6 0000000085E43218 79464003 1 000000008678F208
7 0000000085E43220 79464004 1 0000000086149FA8
8 0000000085E43228 79464005 1 0000000085E491E8
9 0000000085E43230 79464006 1 0000000086791A08
10 0000000085E43238 79464007 1 000000008614C7A8
11 0000000085E43240 79464008 1 0000000085E4B9E8
12 0000000085E43248 79464009 1 0000000086794208
13 0000000085E43250 79464010 1 000000008614EFA8
14 0000000085E43258 79464011 1 0000000085E4E1E8
15 0000000085E43260 79464012 1 0000000086796A08
16 0000000085E43268 79464013 1 00000000861517A8
17 0000000085E43270 79464014 1 0000000085E509E8
18 0000000085E43278 79464015 1 0000000086799208
19 0000000085E43280 79464016 1 0000000086153FA8
20 0000000085E43288 79464017 1 0000000085E531E8
21 0000000085E43290 79464018 1 000000008679BA08
22 0000000085E43298 79464019 1 00000000861567A8
23 0000000085E432A0 79464020 1 0000000085E559E8
24 0000000085E432A8 79464021 1 000000008679E208
25 0000000085E432B0 79464022 1 0000000086158FA8
26 0000000085E432B8 79464023 1 0000000085E581E8
27 0000000085E432C0 79464024 1 00000000867A0A08
28 0000000085E432C8 79464025 1 000000008615B7A8
29 0000000085E432D0 79464026 1 0000000085E5A9E8
30 0000000085E432D8 79464027 1 00000000867A3208
31 0000000085E432E0 79464028 1 000000008615DFA8
32 0000000085E432E8 79464029 1 0000000085E5D1E8
33 0000000085E432F0 79464030 1 00000000867A5A08
34 0000000085E432F8 79464031 1 00000000861607A8
35 0000000085E43300 79464032 1 0000000085E5F9E8
36 0000000085E43308 79464033 1 00000000867A8208
37 0000000085E43310 79464034 1 0000000086162FA8
38 0000000085E43318 79464035 1 0000000085E621E8
39 0000000085E43320 79464036 1 00000000867AAA08
40 0000000085E43328 79464037 1 00000000861657A8
41 0000000085E43330 79464038 1 0000000085E649E8
42 0000000085E43338 79464039 1 00000000867AD208
43 0000000085E43340 79464040 1 0000000086167FA8
44 0000000085E43348 79464041 1 0000000085E671E8
45 0000000085E43350 79464042 1 00000000867AFA08
46 0000000085E43358 79464043 1 000000008616A7A8
47 0000000085E43360 79464044 1 0000000085E699E8
48 0000000085E43368 79464045 1 00000000867B2208
49 0000000085E43370 79464046 1 000000008616CFA8
50 0000000085E43378 79464047 1 0000000085E6C1E8
51 0000000085E43380 79464048 1 00000000867B4A08
52 0000000085E43388 79464049 1 000000008616F7A8
53 0000000085E43390 79464050 1 0000000085E6E9E8
54 0000000085E43398 79464051 1 00000000867B7208
55 0000000085E433A0 79464052 1 0000000086171FA8
56 0000000085E433A8 79464053 1 0000000085E711E8
57 0000000085E433B0 79464054 1 00000000867B9A08
58 0000000085E433B8 79464055 1 00000000861747A8
59 0000000085E433C0 79464056 1 0000000085E739E8
60 0000000085E433C8 79464057 1 00000000867BC208
61 0000000085E433D0 79464058 1 0000000086176FA8
62 0000000085E433D8 79464059 1 0000000085E761E8
63 0000000085E433E0 79464060 1 00000000867BEA08
64 0000000085E433E8 79464061 1 00000000861797A8
65 0000000085E433F0 79464062 1 0000000085E789E8
66 0000000085E433F8 79464063 1 00000000867C1208
67 0000000085E43400 79464064 1 000000008617BFA8
68 0000000085E43408 79464065 1 0000000085E7B1E8
69 0000000085E43410 79464066 1 00000000867C3A08
70 0000000085E43418 79464067 1 000000008617E7A8
71 0000000085E43420 79464068 1 0000000085E7D9E8
72 0000000085E43428 79464069 1 00000000867C6208
73 0000000085E43430 79464070 1 0000000086180FA8
74 0000000085E43438 79464071 1 0000000085E801E8
75 0000000085E43440 79464072 1 00000000867C8A08
76 0000000085E43448 79464073 1 00000000861837A8
77 0000000085E43450 79464074 1 0000000085E829E8
78 0000000085E43458 79464075 1 00000000867CB208
79 0000000085E43460 79464076 1 0000000086185FA8
80 0000000085E43468 79464077 1 0000000085E851E8
81 0000000085E43470 79464078 1 00000000867CDA08
82 0000000085E43478 79464079 1 00000000861887A8
83 0000000085E43480 79464080 1 0000000085E879E8
84 0000000085E43488 79464081 1 00000000867D0208
85 0000000085E43490 79464082 1 000000008618AFA8
86 0000000085E43498 79464083 1 0000000085E8A1E8
87 0000000085E434A0 79464084 1 00000000867D2A08
88 0000000085E434A8 79464085 1 000000008618D7A8
89 0000000085E434B0 79464086 1 0000000085E8C9E8
90 0000000085E434B8 79464087 1 00000000867D5208
91 0000000085E434C0 79464088 1 000000008618FFA8
92 0000000085E434C8 79464089 1 0000000085E8F1E8
93 0000000085E434D0 79464090 1 00000000867D7A08
94 0000000085E434D8 79464091 1 00000000861927A8
95 0000000085E434E0 79464092 1 0000000085E919E8
96 0000000085E434E8 79464093 1 00000000867DA208
97 0000000085E434F0 79464094 1 0000000086194FA8
98 0000000085E434F8 79464095 1 0000000085E941E8
99 0000000085E43500 79464096 1 00000000867DCA08
100 0000000085E43508 79464097 1 00000000861977A8
101 0000000085E43510 79464098 1 0000000085E969E8
102 0000000085E43518 79464099 1 00000000867DF208
103 0000000085E43520 79464100 1 0000000086199FA8
104 0000000085E43528 79464101 1 0000000085E991E8
105 0000000085E43530 79464102 1 00000000867E1A08
106 0000000085E43538 79464103 1 000000008619C7A8
107 0000000085E43540 79464104 1 0000000085E9B9E8
108 0000000085E43548 79464105 1 00000000867E4208
109 0000000085E43550 79464106 1 000000008619EFA8
110 0000000085E43558 79464107 1 0000000085E9E1E8
111 0000000085E43560 79464108 1 00000000867E6A08
112 0000000085E43568 79464109 1 00000000861A17A8
113 0000000085E43570 79464110 1 0000000085EA09E8
114 0000000085E43578 79464111 1 00000000867E9208
115 0000000085E43580 79464112 1 00000000861A3FA8
116 0000000085E43588 79464113 1 0000000085EA31E8
117 0000000085E43590 79464114 1 00000000867EBA08
118 0000000085E43598 79464115 1 00000000861A67A8
119 0000000085E435A0 79464116 1 0000000085EA59E8
120 0000000085E435A8 79464117 1 00000000867EE208
121 0000000085E435B0 79464118 1 00000000861A8FA8
122 0000000085E435B8 79464119 1 0000000085EA81E8
123 0000000085E435C0 79464120 1 00000000867F0A08
124 0000000085E435C8 79464121 1 00000000861AB7A8
125 0000000085E435D0 79464122 1 0000000085EAA9E8
126 0000000085E435D8 79464123 1 00000000867F3208
127 0000000085E435E0 79464124 1 00000000861ADFA8
128 0000000085E435E8 79464125 1 0000000085EAD1E8
129 0000000085E435F0 79464126 1 00000000867F5A08
130 0000000085E435F8 79464127 1 00000000861B07A8
131 0000000085E43600 79464128 1 0000000085EAF9E8
132 0000000085E43608 79464129 1 00000000867F8208
133 0000000085E43610 79464130 1 00000000861B2FA8
134 0000000085E43618 79464131 1 0000000085EB21E8
135 0000000085E43620 79464132 1 00000000867FAA08
136 0000000085E43628 79464133 1 00000000861B57A8
137 0000000085E43630 79464134 1 0000000085EB49E8
138 0000000085E43638 79464135 1 00000000867FD208
139 0000000085E43640 79464136 1 00000000861B7FA8
140 0000000085E43648 79464137 1 0000000085EB71E8
141 0000000085E43650 79464138 1 00000000877FCE10
142 0000000085E43658 79464139 1 00000000861BA7A8
143 0000000085E43660 79464140 1 0000000085EB99E8
144 0000000085E43668 79464141 1 00000000897F1820
145 0000000085E43670 79464142 1 00000000861BCFA8
146 0000000085E43678 79464143 1 0000000085EBC1E8
147 0000000085E43680 79464144 1 00000000897F4020
148 0000000085E43688 79464145 1 00000000861BF7A8
149 0000000085E43690 79464146 1 0000000085EBE9E8
150 0000000085E43698 79464147 1 00000000897F6820
151 0000000085E436A0 79464148 1 00000000861C1FA8
152 0000000085E436A8 79464149 1 0000000085EC11E8
153 0000000085E436B0 79464150 1 00000000897F9020
154 0000000085E436B8 79464151 1 00000000861C47A8
155 0000000085E436C0 79464152 1 0000000085EC39E8
156 0000000085E436C8 79464153 1 00000000897FB820
157 0000000085E436D0 79464154 1 00000000861C6FA8
158 0000000085E436D8 79464155 1 0000000085EC61E8
159 0000000085E436E0 79464156 1 0000000085834020
160 0000000085E436E8 79464157 1 00000000861C97A8
161 0000000085E436F0 79464158 1 0000000085EC89E8
162 0000000085E436F8 79464159 1 0000000085836820
163 0000000085E43700 79464160 1 00000000861CBFA8
164 0000000085E43708 79464161 1 0000000085ECB1E8
165 0000000085E43710 79464162 1 0000000085839020
166 0000000085E43718 79464163 1 00000000861CE7A8
167 0000000085E43720 79464164 1 0000000085ECD9E8
168 0000000085E43728 79464165 1 000000008583B820
169 0000000085E43730 79464166 1 00000000861D0FA8
170 0000000085E43738 79464167 1 0000000085ED01E8
171 0000000085E43740 79464168 1 000000008583E020
172 0000000085E43748 79464169 1 00000000861D37A8
173 0000000085E43750 79464170 1 0000000085ED29E8
174 0000000085E43758 79464171 1 0000000085840820
175 0000000085E43760 79464172 1 00000000861D5FA8
176 0000000085E43768 79464173 1 0000000085ED51E8
177 0000000085E43770 79464174 1 0000000085843020
178 0000000085E43778 79464175 1 00000000861D87A8
179 0000000085E43780 79464176 1 0000000085ED79E8
180 0000000085E43788 79464177 1 0000000085845820
181 0000000085E43790 79464178 1 00000000861DAFA8
182 0000000085E43798 79464179 1 0000000085EDA1E8
183 0000000085E437A0 79464180 1 0000000085848020
184 0000000085E437A8 79464181 1 00000000861DD7A8
185 0000000085E437B0 79464182 1 0000000085EDC9E8
186 0000000085E437B8 79464183 1 000000008584A820
187 0000000085E437C0 79464184 1 00000000861DFFA8
188 0000000085E437C8 79464185 1 0000000085EDF1E8
189 0000000085E437D0 79464186 1 000000008584D020
190 0000000085E437D8 79464187 1 00000000861E27A8
191 0000000085E437E0 79464188 1 0000000085EE19E8
192 0000000085E437E8 79464189 1 000000008584F820
193 0000000085E437F0 79464190 1 00000000861E4FA8
194 0000000085E437F8 79464191 1 0000000085EE41E8
195 0000000085E43800 79464192 1 0000000085852020
196 0000000085E43808 79464193 1 00000000861E77A8
197 0000000085E43810 79464194 1 0000000085EE69E8
198 0000000085E43818 79464195 1 0000000085854820
199 0000000085E43820 79464196 1 00000000861E9FA8
200 0000000085E43828 79464197 1 0000000085EE91E8
201 0000000085E43830 79464198 1 0000000085857020
202 0000000085E43838 79464199 1 00000000861EC7A8
203 0000000085E43840 79464200 1 0000000085EEB9E8
204 0000000085E43848 79464201 1 0000000085859820
205 0000000085E43850 79464202 1 00000000861EEFA8
206 0000000085E43858 79464203 1 0000000085EEE1E8
207 0000000085E43860 79464204 1 000000008585C020
208 0000000085E43868 79464205 1 00000000861F17A8
209 0000000085E43870 79464206 1 0000000085EF09E8
210 0000000085E43878 79464207 1 000000008585E820
211 0000000085E43880 79464208 1 00000000861F3FA8
212 0000000085E43888 79464209 1 0000000085EF31E8
213 0000000085E43890 79464210 1 0000000085861020
214 0000000085E43898 79464211 1 00000000861F67A8
215 0000000085E438A0 79464212 1 0000000085EF59E8
216 0000000085E438A8 79464213 1 0000000085863820
217 0000000085E438B0 79464214 1 00000000861F8FA8
218 0000000085E438B8 79464215 1 0000000085EF81E8
219 0000000085E438C0 79464216 1 0000000085866020
220 0000000085E438C8 79464217 1 00000000861FB7A8
221 0000000085E438D0 79464218 1 0000000085EFA9E8
222 0000000085E438D8 79464219 1 0000000085868820
223 0000000085E438E0 79464220 1 00000000861FDFA8
224 0000000085E438E8 79464221 1 0000000085EFD1E8
225 0000000085E438F0 79464222 1 000000008586B020
226 0000000085E438F8 79464223 1 00000000862007A8
227 0000000085E43900 79464224 1 0000000085EFF9E8
228 0000000085E43908 79464225 1 000000008586D820
229 0000000085E43910 79464226 1 0000000086202FA8
230 0000000085E43918 79464227 1 0000000085F021E8
231 0000000085E43920 79464228 1 0000000085870020
232 0000000085E43928 79464229 1 00000000862057A8
233 0000000085E43930 79464230 1 0000000085F049E8
234 0000000085E43938 79464231 1 0000000085872820
235 0000000085E43940 79464232 1 0000000086207FA8
236 0000000085E43948 79464233 1 0000000085F071E8
237 0000000085E43950 79464234 1 0000000085875020
238 0000000085E43958 79464235 1 000000008620A7A8
239 0000000085E43960 79464236 1 0000000085F099E8
240 0000000085E43968 79464237 1 0000000085877820
241 0000000085E43970 79464238 1 000000008620CFA8
242 0000000085E43978 79464239 1 0000000085F0C1E8
243 0000000085E43980 79464240 1 000000008587A020
244 0000000085E43988 79464241 1 000000008620F7A8
245 0000000085E43990 79464242 1 0000000085F0E9E8
246 0000000085E43998 79464243 1 000000008587C820
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
247 0000000085E439A0 79464244 1 0000000086211FA8
248 0000000085E439A8 79464245 1 0000000085F111E8
249 0000000085E439B0 79464246 1 000000008587F020
250 0000000085E439B8 79464247 1 00000000862147A8
251 0000000085E439C0 79464248 1 0000000085F139E8
252 0000000085E439C8 79464249 1 0000000085881820
253 0000000085E439D0 79464250 1 0000000086216FA8
254 0000000085E439D8 79464251 1 0000000085F161E8
255 0000000085E439E0 79464252 1 0000000085884020
256 0000000085E439E8 79464253 1 00000000862197A8
257 0000000085E439F0 79464254 1 0000000085F189E8
258 0000000085E439F8 79464255 1 0000000085886820
259 0000000085E43A00 79464256 1 000000008621BFA8
260 0000000085E43A08 79464257 1 0000000085F1B1E8
261 0000000085E43A10 79464258 1 0000000085889020
262 0000000085E43A18 79464259 1 000000008621E7A8
263 0000000085E43A20 79464260 1 0000000085F1D9E8
264 0000000085E43A28 79464261 1 000000008588B820
265 0000000085E43A30 79464262 1 0000000086220FA8
266 0000000085E43A38 79464263 1 0000000085F201E8
267 0000000085E43A40 79464264 1 000000008588E020
268 0000000085E43A48 79464265 1 00000000862237A8
269 0000000085E43A50 79464266 1 0000000085F229E8
270 0000000085E43A58 79464267 1 0000000085890820
271 0000000085E43A60 79464268 1 0000000086225FA8
272 0000000085E43A68 79464269 1 0000000085F251E8
273 0000000085E43A70 79464270 1 0000000085893020
274 0000000085E43A78 79464271 1 00000000862287A8
275 0000000085E43A80 79464272 1 0000000085F279E8
276 0000000085E43A88 79464273 1 0000000085895820
277 0000000085E43A90 79464274 1 000000008622AFA8
278 0000000085E43A98 79464275 1 0000000085F2A1E8
279 0000000085E43AA0 79464276 1 0000000085898020
280 0000000085E43AA8 79464277 1 000000008622D7A8
281 0000000085E43AB0 79464278 1 0000000085F2C9E8
282 0000000085E43AB8 79464279 1 000000008589A820
283 0000000085E43AC0 79464280 1 000000008622FFA8
284 0000000085E43AC8 79464281 1 0000000085F2F1E8
285 0000000085E43AD0 79464282 1 000000008589D020
286 0000000085E43AD8 79464283 1 00000000862327A8
287 0000000085E43AE0 79464284 1 0000000085F319E8
288 0000000085E43AE8 79464285 1 000000008589F820
289 0000000085E43AF0 79464286 1 0000000086234FA8
290 0000000085E43AF8 79464287 1 0000000085F341E8
291 0000000085E43B00 79464288 1 00000000858A2020
292 0000000085E43B08 79464289 1 00000000862377A8
293 0000000085E43B10 79464290 1 0000000085F369E8
294 0000000085E43B18 79464291 1 00000000858A4820
295 0000000085E43B20 79464292 1 0000000086239FA8
296 0000000085E43B28 79464293 1 0000000085F391E8
297 0000000085E43B30 79464294 1 00000000858A7020
298 0000000085E43B38 79464295 1 000000008623C7A8
299 0000000085E43B40 79464296 1 0000000085F3B9E8
300 0000000085E43B48 79464297 1 00000000858A9820
301 0000000085E43B50 79464298 1 000000008623EFA8
302 0000000085E43B58 79464299 1 0000000085F3E1E8
303 0000000085E43B60 79464300 1 00000000858AC020
304 0000000085E43B68 79464301 1 00000000862417A8
305 0000000085E43B70 79464302 1 0000000085F409E8
306 0000000085E43B78 79464303 1 00000000858AE820
307 0000000085E43B80 79464304 1 0000000086243FA8
308 0000000085E43B88 79464305 1 0000000085F431E8
309 0000000085E43B90 79464306 1 00000000858B1020
310 0000000085E43B98 79464307 1 00000000862467A8
311 0000000085E43BA0 79464308 1 0000000085F459E8
312 0000000085E43BA8 79464309 1 00000000858B3820
313 0000000085E43BB0 79464310 1 0000000086248FA8
314 0000000085E43BB8 79464311 1 0000000085F481E8
315 0000000085E43BC0 79464312 1 00000000858B6020
316 0000000085E43BC8 79464313 1 000000008624B7A8
317 0000000085E43BD0 79464314 1 0000000085F4A9E8
318 0000000085E43BD8 79464315 1 00000000858B8820
319 0000000085E43BE0 79464316 1 000000008624DFA8
320 0000000085E43BE8 79464317 1 0000000085F4D1E8
321 0000000085E43BF0 79464318 1 00000000858BB020
322 0000000085E43BF8 79464319 1 00000000862507A8
323 0000000085E43C00 79464320 1 0000000085F4F9E8
324 0000000085E43C08 79464321 1 00000000858BD820
325 0000000085E43C10 79464322 1 0000000086252FA8
326 0000000085E43C18 79464323 1 0000000085F521E8
327 0000000085E43C20 79464324 1 00000000858C0020
328 0000000085E43C28 79464325 1 00000000862557A8
329 0000000085E43C30 79464326 1 0000000085F549E8
330 0000000085E43C38 79464327 1 00000000858C2820
331 0000000085E43C40 79464328 1 0000000086257FA8
332 0000000085E43C48 79464329 1 0000000085F571E8
333 0000000085E43C50 79464330 1 00000000858C5020
334 0000000085E43C58 79464331 1 000000008625A7A8
335 0000000085E43C60 79464332 1 0000000085F599E8
336 0000000085E43C68 79464333 1 00000000858C7820
337 0000000085E43C70 79464334 1 000000008625CFA8
338 0000000085E43C78 79464335 1 0000000085F5C1E8
339 0000000085E43C80 79464336 1 00000000858CA020
340 0000000085E43C88 79464337 1 000000008625F7A8
341 0000000085E43C90 79464338 1 0000000085F5E9E8
342 0000000085E43C98 79464339 1 00000000858CC820
343 0000000085E43CA0 79464340 1 0000000086261FA8
344 0000000085E43CA8 79464341 1 0000000085F611E8
345 0000000085E43CB0 79464342 1 00000000858CF020
346 0000000085E43CB8 79464343 1 00000000862647A8
347 0000000085E43CC0 79464344 1 0000000085F639E8
348 0000000085E43CC8 79464345 1 00000000858D1820
349 0000000085E43CD0 79464346 1 0000000086266FA8
350 0000000085E43CD8 79464347 1 0000000085F661E8
351 0000000085E43CE0 79464348 1 00000000858D4020
352 0000000085E43CE8 79464349 1 00000000862697A8
353 0000000085E43CF0 79464350 1 0000000085F689E8
354 0000000085E43CF8 79464351 1 00000000858D6820
355 0000000085E43D00 79464352 1 000000008626BFA8
356 0000000085E43D08 79464353 1 0000000085F6B1E8
357 0000000085E43D10 79464354 1 00000000858D9020
358 0000000085E43D18 79464355 1 000000008626E7A8
359 0000000085E43D20 79464356 1 0000000085F6D9E8
360 0000000085E43D28 79464357 1 00000000858DB820
361 0000000085E43D30 79464358 1 0000000086270FA8
362 0000000085E43D38 79464359 1 0000000085F701E8
363 0000000085E43D40 79464360 1 00000000858DE020
364 0000000085E43D48 79464361 1 00000000862737A8
365 0000000085E43D50 79464362 1 0000000085F729E8
366 0000000085E43D58 79464363 1 00000000858E0820
367 0000000085E43D60 79464364 1 0000000086275FA8
368 0000000085E43D68 79464365 1 0000000085F751E8
369 0000000085E43D70 79464366 1 00000000858E3020
370 0000000085E43D78 79464367 1 00000000862787A8
371 0000000085E43D80 79464368 1 0000000085F779E8
372 0000000085E43D88 79464369 1 00000000858E5820
373 0000000085E43D90 79464370 1 000000008627AFA8
374 0000000085E43D98 79464371 1 0000000085F7A1E8
375 0000000085E43DA0 79464372 1 00000000858E8020
376 0000000085E43DA8 79464373 1 000000008627D7A8
377 0000000085E43DB0 79464374 1 0000000085F7C9E8
378 0000000085E43DB8 79464375 1 00000000858EA820
379 0000000085E43DC0 79464376 1 000000008627FFA8
380 0000000085E43DC8 79464377 1 0000000085F7F1E8
381 0000000085E43DD0 79464378 1 00000000858ED020
382 0000000085E43DD8 79464379 1 00000000862827A8
383 0000000085E43DE0 79464380 1 0000000085F819E8
384 0000000085E43DE8 79464381 1 00000000858EF820
385 0000000085E43DF0 79464382 1 0000000086284FA8
386 0000000085E43DF8 79464383 1 0000000085F841E8
387 0000000085E43E00 79464384 1 00000000858F2020
388 0000000085E43E08 79464385 1 00000000862877A8
389 0000000085E43E10 79464386 1 0000000085F869E8
390 0000000085E43E18 79464387 1 00000000858F4820
391 0000000085E43E20 79464388 1 0000000086289FA8
392 0000000085E43E28 79464389 1 0000000085F891E8
393 0000000085E43E30 79464390 1 00000000858F7020
394 0000000085E43E38 79464391 1 000000008628C7A8
395 0000000085E43E40 79464392 1 0000000085F8B9E8
396 0000000085E43E48 79464393 1 00000000858F9820
397 0000000085E43E50 79464394 1 000000008628EFA8
398 0000000085E43E58 79464395 1 0000000085F8E1E8
399 0000000085E43E60 79464396 1 00000000858FC020
400 0000000085E43E68 79464397 1 00000000862917A8
401 0000000085E43E70 79464398 1 0000000085F909E8
402 0000000085E43E78 79464399 1 00000000858FE820
403 0000000085E43E80 79464400 1 0000000086293FA8
404 0000000085E43E88 79464401 1 0000000085F931E8
405 0000000085E43E90 79464402 1 0000000085901020
406 0000000085E43E98 79464403 1 00000000862967A8
407 0000000085E43EA0 79464404 1 0000000085F959E8
408 0000000085E43EA8 79464405 1 0000000085903820
409 0000000085E43EB0 79464406 1 0000000086298FA8
410 0000000085E43EB8 79464407 1 0000000085F981E8
411 0000000085E43EC0 79464408 1 0000000085906020
412 0000000085E43EC8 79464409 1 000000008629B7A8
413 0000000085E43ED0 79464410 1 0000000085F9A9E8
414 0000000085E43ED8 79464411 1 0000000085908820
415 0000000085E43EE0 79464412 1 000000008629DFA8
416 0000000085E43EE8 79464413 1 0000000085F9D1E8
417 0000000085E43EF0 79464414 1 000000008590B020
418 0000000085E43EF8 79464415 1 00000000862A07A8
419 0000000085E43F00 79464416 1 0000000085F9F9E8
420 0000000085E43F08 79464417 1 000000008590D820
421 0000000085E43F10 79464418 1 00000000862A2FA8
422 0000000085E43F18 79464419 1 0000000085FA21E8
423 0000000085E43F20 79464420 1 0000000085910020
424 0000000085E43F28 79464421 1 00000000862A57A8
425 0000000085E43F30 79464422 1 0000000085FA49E8
426 0000000085E43F38 79464423 1 0000000085912820
427 0000000085E43F40 79464424 1 00000000862A7FA8
428 0000000085E43F48 79464425 1 0000000085FA71E8
429 0000000085E43F50 79464426 1 0000000085915020
430 0000000085E43F58 79464427 1 00000000862AA7A8
431 0000000085E43F60 79464428 1 0000000085FA99E8
432 0000000085E43F68 79464429 1 0000000085917820
433 0000000085E43F70 79464430 1 00000000862ACFA8
434 0000000085E43F78 79464431 1 0000000085FAC1E8
435 0000000085E43F80 79464432 1 000000008591A020
436 0000000085E43F88 79464433 1 00000000862AF7A8
437 0000000085E43F90 79464434 1 0000000085FAE9E8
504 0000000085E441A0 79464500 1 0000000085FE59E8 [456/29992]
438 0000000085E43F98 79464435 1 000000008591C820
439 0000000085E43FA0 79464436 1 00000000862B1FA8
440 0000000085E43FA8 79464437 1 0000000085FB11E8
441 0000000085E43FB0 79464438 1 000000008591F020
442 0000000085E43FB8 79464439 1 00000000862B47A8
443 0000000085E43FC0 79464440 1 0000000085FB39E8
444 0000000085E43FC8 79464441 1 0000000085921820
445 0000000085E43FD0 79464442 1 00000000862B6FA8
446 0000000085E43FD8 79464443 1 0000000085FB61E8
447 0000000085E43FE0 79464444 1 0000000085924020
448 0000000085E43FE8 79464445 1 00000000862B97A8
449 0000000085E43FF0 79464446 1 0000000085FB89E8
450 0000000085E43FF8 79464447 1 0000000085926820
451 0000000085E44000 79464448 1 00000000862BBFA8
452 0000000085E44008 79464449 1 0000000085FBB1E8
453 0000000085E44010 79464450 1 0000000085929020
454 0000000085E44018 79464451 1 00000000862BE7A8
455 0000000085E44020 79464452 1 0000000085FBD9E8
456 0000000085E44028 79464453 1 000000008592B820
457 0000000085E44030 79464454 1 00000000862C0FA8
458 0000000085E44038 79464455 1 0000000085FC01E8
459 0000000085E44040 79464456 1 000000008592E020
460 0000000085E44048 79464457 1 00000000862C37A8
461 0000000085E44050 79464458 1 0000000085FC29E8
462 0000000085E44058 79464459 1 0000000085930820
463 0000000085E44060 79464460 1 00000000862C5FA8
464 0000000085E44068 79464461 1 0000000085FC51E8
465 0000000085E44070 79464462 1 0000000085933020
466 0000000085E44078 79464463 1 00000000862C87A8
467 0000000085E44080 79464464 1 0000000085FC79E8
468 0000000085E44088 79464465 1 0000000085935820
469 0000000085E44090 79464466 1 00000000862CAFA8
470 0000000085E44098 79464467 1 0000000085FCA1E8
471 0000000085E440A0 79464468 1 0000000085938020
472 0000000085E440A8 79464469 1 00000000862CD7A8
473 0000000085E440B0 79464470 1 0000000085FCC9E8
474 0000000085E440B8 79464471 1 000000008593A820
475 0000000085E440C0 79464472 1 00000000862CFFA8
476 0000000085E440C8 79464473 1 0000000085FCF1E8
477 0000000085E440D0 79464474 1 000000008593D020
478 0000000085E440D8 79464475 1 00000000862D27A8
479 0000000085E440E0 79464476 1 0000000085FD19E8
480 0000000085E440E8 79464477 1 000000008593F820
481 0000000085E440F0 79464478 1 00000000862D4FA8
482 0000000085E440F8 79464479 1 0000000085FD41E8
483 0000000085E44100 79464480 1 0000000085942020
484 0000000085E44108 79464481 1 00000000862D77A8
485 0000000085E44110 79464482 1 0000000085FD69E8
486 0000000085E44118 79464483 1 0000000085944820
487 0000000085E44120 79464484 1 00000000862D9FA8
488 0000000085E44128 79464485 1 0000000085FD91E8
489 0000000085E44130 79464486 1 0000000085947020
490 0000000085E44138 79464487 1 00000000862DC7A8
491 0000000085E44140 79464488 1 0000000085FDB9E8
492 0000000085E44148 79464489 1 0000000085949820
493 0000000085E44150 79464490 1 00000000862DEFA8
494 0000000085E44158 79464491 1 0000000085FDE1E8
495 0000000085E44160 79464492 1 000000008594C020
496 0000000085E44168 79464493 1 00000000862E17A8
497 0000000085E44170 79464494 1 0000000085FE09E8
498 0000000085E44178 79464495 1 000000008594E820
499 0000000085E44180 79464496 1 00000000862E3FA8
500 0000000085E44188 79464497 1 0000000085FE31E8
501 0000000085E44190 79464498 1 0000000085951020
502 0000000085E44198 79464499 1 00000000862E67A8
503 0000000085E441A0 79464500 1 0000000085FE59E8
504 0000000085E441A8 79464501 1 0000000085953820
505 0000000085E441B0 79464502 1 00000000862E8FA8
506 0000000085E441B8 79464503 1 0000000085FE81E8
507 0000000085E441C0 79464504 1 0000000085956020
508 0000000085E441C8 79464505 1 00000000862EB7A8
509 0000000085E441D0 79464506 1 0000000085FEA9E8
510 0000000085E441D8 79464507 1 0000000085958820
511 0000000085E441E0 79464508 1 00000000862EDFA8
512 rows selected.
--//注意看最后一列KSMMMVAL，可以发现上下间隔不再是10240.观察最后2位就可以确定。我开始看也怀疑该数组是否不再这个位置或者
--//这样的组织方式,想起前面的输出在几个chunk上跳来跳去，仔细看rn=0,3,6,9,12行，可以发现满足间隔是10240.
RN ADDR INDX INST_ID KSMMMVAL
---------- ---------------- ---------- ---------- ----------------
0 0000000085E431E8 79463997 1 000000008678A208
3 0000000085E43200 79464000 1 000000008678CA08
6 0000000085E43218 79464003 1 000000008678F208
9 0000000085E43230 79464006 1 0000000086791A08
12 0000000085E43248 79464009 1 0000000086794208
--//KSMMMVAL上下相减
--//8678CA08 - 8678A208 = 10240
--//8678F208 - 8678CA08 = 10240
--//86791A08 - 8678F208 = 10240
--//86794208 - 86791A08 = 10240
--//实际上这个时候你可以大致猜测oracle定位library cache mutex地址的大致算法与前面完全一致。
--//确定基地址A x0000000085E431E8，计算sql语句的hash_value获得bucket值，使用bucket/256 取整就可以定位 该数组的地址 等于
--//A + trunc(bucket/256)*8 ,再通过bucket%256 * 40 + A + trunc(bucket/256)*8 , 就知道定位该bucket的library cache mutex
--//的地址。
4.通过一个例子来讲解如何定位该bucket地址的.
SYS@book> Select sysdate from dual ;
SYSDATE
-------------------
2022-03-03 09:12:01
SYS@book> @ hash
HASH_VALUE SQL_ID CHILD_NUMBER KGL_BUCKET PLAN_HASH_VALUE HASH_HEX SQL_EXEC_START SQL_EXEC_ID
---------- ------------- ------------ ---------- --------------- ---------- ------------------- -----------
381482536 dvk83p4bbtxj8 0 63016 1388734953 16bcf628 2022-03-03 09:12:01 16777216
--//HASH_VALUE=381482536,KGL_BUCKET=63016.
--//计算方法 381482536%(2^9*256) = 63016。 bucket值等于63016。
SYS@book> select trunc (63016 /256 ), mod(63016 ,256) from dual ;
TRUNC(63016/256) MOD(63016,256)
---------------- --------------
246 40
--// 0 0000000085E431E8 79463997 1 000000008678A208
--// 246 0000000085E43998 79464243 1 000000008587C820
--//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--//注意bucket从0开始计数。对应前面++++行(246行)。地址为000000008587C820.
--//246*8 = 1968
SYS@book> @ tpt/calc x0000000085E431E8 + 1968
DEC HEX
----------------------------------- --------------------
2246326680.000000 85E43998
--//注意看前面++++行，正好对应ADDR值0000000085E43998，通过这个地址，知道保存的值KSMMMVAL=x000000008587C820
--//MOD(63016,256)=40, 40*40 = 1600
SYS@book> @ tpt/calc x000000008587C820 + 1600
DEC HEX
----------------------------------- --------------------
2240269920.000000 8587CE60
--//x8587CE60这个地址记录的就是bucket = 63016 的开始地址。
SYS@book> oradebug setmypid
Statement processed.
SYS@book> oradebug peek 0x8587CE60 40
[08587CE60, 08587CE88) = 8273FC18 00000000 8273FC18 00000000 00000000 00000000 0000000B 00000000 0000F628 00000000
--//执行如下，注意我的测试设置session_cached_cursors=50，多次执行后会变成"软软解析"登录会话第一次后执行的是软解析。
--//我采用的执行方式是执行完成马上退出。
$ echo "Select sysdate from dual ;"|sqlplus -s -l / as sysdba
SYSDATE
-------------------
2022-03-03 11:43:50
--//每执行以上语句1次，使用oradebug peek 0x8587CE60 40在另外会话查询该地址 保存前40字节内容。
SYS@book> oradebug peek 0x8587CE60 40
[08587CE60, 08587CE88) = 8273FC18 00000000 8273FC18 00000000 00000000 00000000 0000000B 00000000 0000F628 00000000
SYS@book> oradebug peek 0x8587CE60 40
[08587CE60, 08587CE88) = 8273FC18 00000000 8273FC18 00000000 00000000 00000000 0000000C 00000000 0000F628 00000000
SYS@book> oradebug peek 0x8587CE60 40
[08587CE60, 08587CE88) = 8273FC18 00000000 8273FC18 00000000 00000000 00000000 0000000D 00000000 0000F628 00000000
SYS@book> oradebug peek 0x8587CE60 40
[08587CE60, 08587CE88) = 8273FC18 00000000 8273FC18 00000000 00000000 00000000 0000000E 00000000 0000F628 00000000
--//注意看mutex结构的第4双字节内容，这里就是第8双字节内容的变化，0x0B->0x0C->0x0D->0x0E，每次执行后增加1.
--//你可以打开一个新会话，执行如下：
SYS@book> Select sysdate from dual ;
SYSDATE
-------------------
2022-03-03 11:45:49
SYS@book> Select sysdate from dual ;
SYSDATE
-------------------
2022-03-03 11:45:54
SYS@book> oradebug peek 0x8587CE60 40
[08587CE60, 08587CE88) = 8273FC18 00000000 8273FC18 00000000 00000000 00000000 0000000E 00000000 0000F628 00000000
SYS@book> oradebug peek 0x8587CE60 40
[08587CE60, 08587CE88) = 8273FC18 00000000 8273FC18 00000000 00000000 00000000 0000000F 00000000 0000F628 00000000
SYS@book> oradebug peek 0x8587CE60 40
[08587CE60, 08587CE88) = 8273FC18 00000000 8273FC18 00000000 00000000 00000000 0000000F 00000000 0000F628 00000000
--//你可以发现第2次执行就是软软解析，不再touch该bucket。gets的数量不再增加。
SYS@book> @ sharepool/shp4 dvk83p4bbtxj8 0
TEXT KGLHDADR KGLHDPAR C40 KGLHDLMD KGLHDPMD KGLHDIVC KGLOBHD0 KGLOBHD6 KGLOBHS0 KGLOBHS6 KGLOBT16 N0_6_16 N20 KGLNAHSH KGLOBT03 KGLOBT09
--------------------- ---------------- ---------------- ---------------------------------------- ---------- ---------- ---------- ---------------- ---------------- ---------- ---------- ---------- --------- ---------- ---------- ------------- ----------
child handle address 0000000083D930D8 000000008273FC18 Select sysdate from dual 0 0 0 0000000083EBE590 0000000083EBEDA0 4528 8088 3082 15698 15698 381482536 dvk83p4bbtxj8 0
parent handle address 000000008273FC18 000000008273FC18 Select sysdate from dual 0 0 0 000000008278F0B0 00 4720 0 0 4720 4720 381482536 dvk83p4bbtxj8 65535
--//你可以发现bucket地址记录的内容前面就是该语句sql_id=dvk83p4bbtxj8的父游标地址x000000008273FC18.
--//如果你查看父游标0x81EC41D0 开始40字节内容。
SYS@book> oradebug peek 0x000000008273FC18 40
[08273FC18, 08273FC40) = 8587CE60 00000000 8587CE60 00000000 83EBE6C8 00000000 8273FD70 00000000 00000000 10012841
--//开始部分x8587CE60正好是该bucket的地址，oracle正是通过这样的方式链接多个bucket一样的sql语句。
--//关于这部分内容大家可以参考，链接：http://blog.itpub.net/267265/viewspace-2775038/=>[20210602]分析library cache转储 5.txt
--//总之这个地址表是存在的,至于为什么在_kghdsidx_count<>1的情况下这样组织,我就不知道了.
5. 附上shp4.sql脚本：
$ cat sharepool/shp4.sql
column N0_6_16 format 99999999
SELECT DECODE (kglhdadr,
kglhdpar, "parent handle address",
"child handle address")
text,
kglhdadr,
kglhdpar,
substr(kglnaobj,1,40) c40,
KGLHDLMD,
KGLHDPMD,
kglhdivc,
kglobhd0,
kglobhd6,
kglobhs0,kglobhs6,kglobt16,
kglobhs0+kglobhs6+kglobt16 N0_6_16,
kglobhs0+kglobhs1+kglobhs2+kglobhs3+kglobhs4+kglobhs5+kglobhs6+kglobt16 N20,
kglnahsh,
kglobt03 ,
kglobt09
FROM x$kglob
WHERE kglobt03 = "&1" or kglhdpar="&1" or kglhdadr="&1" or KGLNAHSH= &2;
--//另外fcha.sql ,calc.sql脚本来自Tanel Poder的TPT脚本。在tanelpoder.com/downloads/可以下载。
6.今天上班重启服务器参数没有改变，查看发现该表位置不变，但是记录bucket 0的地址发生了变化。
SYS@book> @ hide _kghdsidx_count
NAME DESCRIPTION DEFAULT_VALUE SESSION_VALUE SYSTEM_VALUE ISSES ISSYS_MOD
---------------------------------------- ------------------------------------------------------------------ ---------------------- ---------------------- ---------------------- ----- ---------
_kghdsidx_count max kghdsidx count FALSE 3 3 FALSE FALSE
SYS@book> @ hide _kgl_bucket_count
NAME DESCRIPTION DEFAULT_VALUE SESSION_VALUE SYSTEM_VALUE ISSES ISSYS_MOD
---------------------------------------- ------------------------------------------------------------------ ---------------------- ---------------------- ---------------------- ----- ---------
_kgl_bucket_count Library cache hash table bucket count (2^_kgl_bucket_count * 256) TRUE 9 9 FALSE FALSE
SELECT rownum-1 rn
, x$ksmmem.*
FROM X$KSMMEM
WHERE addr between hextoraw("0000000085E431E8") and hextoraw("0000000085E441E0");
RN ADDR INDX INST_ID KSMMMVAL
---------- ---------------- ---------- ---------- ----------------
0 0000000085E431E8 79463997 1 000000008678A508
1 0000000085E431F0 79463998 1 0000000086144FA8
2 0000000085E431F8 79463999 1 0000000085E441E8
3 0000000085E43200 79464000 1 000000008678CD08
4 0000000085E43208 79464001 1 00000000861477A8
5 0000000085E43210 79464002 1 0000000085E469E8
6 0000000085E43218 79464003 1 000000008678F508
7 0000000085E43220 79464004 1 0000000086149FA8
8 0000000085E43228 79464005 1 0000000085E491E8
9 0000000085E43230 79464006 1 0000000086791D08
...
SYS@book> @ fchaz 000000008678A508
LOC KSMCHPTR KSMCHIDX KSMCHDUR KSMCHCOM KSMCHSIZ KSMCHCLS KSMCHTYP KSMCHPAR KSMCHPTR_END
--- ---------------- ---------- ---------- ---------------- ---------- -------- ---------- ---------------- -----------------
SGA 0000000086434000 1 1 permanent memor 3980552 perm 0 00 00000000867FFD07
--//不知道为什么，仅仅做一个记录吧。
以上是 [20220303]oracle如何定位使用librarycachemutex3.txt 的全部内容， 来源链接： utcz.com/z/536320.html
