ITPub博客

首页 > 数据库 > Oracle > [20260812]简单探究row cache mutex的相关问题.txt

[20260812]简单探究row cache mutex的相关问题.txt

原创 Oracle 作者:lfree 时间:2026-08-19 20:45:15 0 删除 编辑

[20260812]简单探究row cache mutex的相关问题.txt

--//继续昨天的探究.
--//假设一个表scott.dept,对象类型dc_objects,oracle如何确定那些chunk上寻找row cache mutex以及row cache hash呢?  必须还
--//有chunk记录这些信息.

1.环境:
SYS@book> @ ver2
==============================
PORT_STRING                   : x86_64/Linux 2.4.xx
VERSION                       : 21.0.0.0.0
BANNER                        : Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
BANNER_FULL                   : Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
BANNER_LEGACY                 : Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
CON_ID                        : 0
PL/SQL procedure successfully completed.

2.分析:
SELECT a.*
      ,CASE
          WHEN ksmchcom = 'row cache mutex' AND MOD (KSMCHSIZ - 16, 24) = 0 THEN (KSMCHSIZ - 16) / 24
          WHEN ksmchcom = 'row cache mutex' AND MOD (KSMCHSIZ - 16, 24) <> 0 THEN (KSMCHSIZ - 16) / 4
          WHEN ksmchcom = 'row cache hash' AND MOD (KSMCHSIZ - 16, 16) = 0 THEN (KSMCHSIZ - 16) / 16
       END
          buckets
  FROM x$ksmsp a
 WHERE KSMCHCOM like 'row cache %' ;

ADDR                   INDX    INST_ID     CON_ID   KSMCHIDX   KSMCHDUR KSMCHCOM         KSMCHPTR           KSMCHSIZ KSMCHCLS   KSMCHTYP KSMCHPAR            BUCKETS
---------------- ---------- ---------- ---------- ---------- ---------- ---------------- ---------------- ---------- -------- ---------- ---------------- ----------
...
00007FD9EB702A80      99864          1          1          1          1 row cache mutex  00000000760C3958       1040 perm              0 0000000076081000        256
00007FD9EB702A18      99865          1          1          1          1 row cache mutex  00000000760C2148       6160 perm              0 0000000076081000        256
00007FD9EB7029B0      99866          1          1          1          1 row cache hash   00000000760C1138       4112 perm              0 0000000076081000        256
...
--//单独拿其中一段看看,注我的测试环境每次重启该地址不会变化的,我没有修改sga相关配置.
--//以前11下可以使用x$ksmmem视图查询,但是21c仅仅取其中1个共享内存段:
YS@book> select max(ADDR),min(addr)  from x$ksmmem ;
MAX(ADDR)        MIN(ADDR)
---------------- ----------------
000000006093C7F0 0000000060000000

$ pmap -x $(pgrep pmon) | egrep  -i "sysv|^Address"
Address           Kbytes     RSS   Dirty Mode  Mapping
0000000060000000   10240       0       0 rw-s- SYSV00000000 (deleted)
0000000061000000 1114112       0       0 rw-s- SYSV00000000 (deleted)
00000000a5000000    8192       0       0 rw-s- SYSV00000000 (deleted)
00000000a6000000    2048       0       0 rw-s- SYSVafa94c20 (deleted)
--//仅仅查询到0000000060000000这个内存段,真正需要查询的信息在0000000061000000.

--//21c可以尝试使用dumpsga转储sga信息:

$ mdkir sga
$ export DUMPSGA_DIR=/home/oracle/sga
$ cd sga
$ dumpsga
$ cd $DUMPSGA_DIR/
$ ll

 $ ll -R $DUMPSGA_DIR
/home/oracle/sga:
total 0
drwxr-x---. 2 oracle oinstall 87 2026-08-12 16:41:30 Aug_12_16:41:17_2026

'/home/oracle/sga/Aug_12_16:41:17_2026':
total 1134596
-rw-rw----. 1 oracle oinstall   10485760 2026-08-12 16:41:30 60000000
-rw-rw----. 1 oracle oinstall 1140850688 2026-08-12 16:41:17 61000000
-rw-rw----. 1 oracle oinstall    8388608 2026-08-12 16:41:30 a5000000
-rw-rw----. 1 oracle oinstall    2097152 2026-08-12 16:41:30 a6000000
-rw-rw----. 1 oracle oinstall       1752 2026-08-12 16:41:30 diagmdata
--//建立一个带时间戳的目录,里面包含如上文件,命名方式很容易看出与前面pmap -x 的输出的Address相关.通过文件大小也可以相互验
--//证.

--//将前面字段KSMCHPTR的3个地址分别加上0x10(16).
0x00000000760C3958 + 0x10  = 0x760c3968
0x00000000760C2148 + 0x10  = 0x760c2158
0x00000000760C1138 + 0x10  = 0x760c1148

--//根据地址0x760c3948,很容易确定在61000000文件中.

$ cd Aug_12_16\:41\:17_2026/

$ od -t x8  -A x -w64  61000000 | egrep -i "00000000760c3968|00000000760c2158|00000000760c1148"
150c1080 00000000760c1148 0000000000000000 0000000000000000 00000000774c9238 0000000000000000 00000000760c1130 00000000760c2158 00000000760c3968
         ~~~~~~~~~~~~~~~~                                                                                      ~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~
150c1140 0000000016b4e6b4 00000000760c1148 00000000760c1148 00000000760c1158 00000000760c1158 00000000760c1168 00000000760c1168 00000000760c1178
                          ~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~

--//注:使用下划线表示过滤查询的结果.
--//位于 0x150c1080+0x0000000061000000 = 0x760c1080,0x150c1140+0x0000000061000000  = 0x760c1140.
SYS@book> @ fchaz 0x760c1080
LOC  KSMCHPTR           KSMCHIDX   KSMCHDUR KSMCHCOM                           KSMCHSIZ KSMCHCLS   KSMCHTYP KSMCHPAR         KSMCHPTR_BEGIN   KSMCHPTR_END+1
---- ---------------- ---------- ---------- -------------------------------- ---------- -------- ---------- ---------------- ---------------- -----------------
VSGA 00000000760C1030          1          1 row cache                               144 perm              0 0000000076081000 00000000760C1030 00000000760C10C0

SYS@book> @ fchaz 0x760c1140
LOC  KSMCHPTR           KSMCHIDX   KSMCHDUR KSMCHCOM                           KSMCHSIZ KSMCHCLS   KSMCHTYP KSMCHPAR         KSMCHPTR_BEGIN   KSMCHPTR_END+1
---- ---------------- ---------- ---------- -------------------------------- ---------- -------- ---------- ---------------- ---------------- -----------------
VSGA 00000000760C1138          1          1 row cache hash                         4112 perm              0 0000000076081000 00000000760C1138 00000000760C2148
--//后面出现2次位于row cache hash,表示bucket=0的没有对象.

--//可以发现三个地址的信息在KSMCHSIZ=144的chunk中.KSMCHPTR_BEGIN=00000000760C1030
SYS@book> @ opeek 00000000760C1030 144 1
New tracefile_identifier = /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_3070_0001.trc
[0760C1030, 0760C10C0) = 00000091 00B38F00 16B4E6AA 00000000 760C10D0 00000000 760C1118 00000000 760C10E8 00000000 760C1100 00000000 01900001 00000028 ...

--//查看转储文件:
Processing Oradebug command 'peek 0x00000000760c1030 144 1'
[0760C1030, 0760C10C0) = 00000091 00B38F00 16B4E6AA 00000000 760C10D0 ...
Dump of memory from 0x0760C1044 to 0x0760C10C0
0760C1040          00000000 760C1118 00000000      [.......v....]
0760C1050 760C10E8 00000000 760C1100 00000000  [...v.......v....]
0760C1060 01900001 00000028 16B4E808 00000000  [....(...........]
0760C1070 00000011 00000000 00000100 00000000  [................]
                            ++++++++
0760C1080 760C1148 00000000 00000000 00000000  [H..v............]
          ~~~~~~~~~~~~~~~~       
0760C1090 00000000 00000000 774C9238 00000000  [........8.Lw....]
0760C10A0 00000000 00000000 760C1130 00000000  [........0..v....]
0760C10B0 760C2158 00000000 760C3968 00000000  [X!.v....h9.v....]
          ~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~
*** 2026-08-13T15:45:32.889509+08:00 (CDB$ROOT(1))
--//加号指向的信息猜测表示BUCKETS的大小,换算十进制表示256.
--//偏移0x0760C1078-0x0760C1030 = 0x48 = 72 。

SYS@book> select count(*) from x$ksmsp where KSMCHSIZ=144 and KSMCHCOM='row cache';
  COUNT(*)
----------
        62
--//又是正好等于62.

--//再次改写前面写的sql语句:
$ cat row_cache.sql
column INDX format 999999
column INST_ID format 9999999
column con_id format 99999
column kSMCHIDX format 99999999
column KSMCHDUR format 99999999
column KSMCHCOM format a15
column KSMCHTYP format 99999999
column BUCKETS format 999999

SELECT a.*
      ,CASE
          WHEN ksmchcom = 'row cache mutex' AND MOD (KSMCHSIZ - 16, 24) = 0 THEN (KSMCHSIZ - 16) / 24
          WHEN ksmchcom = 'row cache mutex' AND MOD (KSMCHSIZ - 16, 24) <> 0 THEN (KSMCHSIZ - 16) / 4
          WHEN ksmchcom = 'row cache hash' AND MOD (KSMCHSIZ - 16, 16) = 0 THEN (KSMCHSIZ - 16) / 16
       END
          buckets
      ,a.KSMCHPTR KSMCHPTR_BEGIN
      ,TO_CHAR (TO_NUMBER (a.KSMCHPTR, 'XXXXXXXXXXXXXXXX') + a.KSMCHSIZ, 'FM0XXXXXXXXXXXXXXX') "KSMCHPTR_END+1"
  FROM x$ksmsp a
 WHERE KSMCHCOM LIKE 'row cache %' OR (KSMCHCOM = 'row cache' AND (KSMCHSIZ = 144 OR ksmchsiz = 24 or ksmchsiz=32));

SYS@book> @ row_cache

ADDR                INDX  INST_ID CON_ID  KSMCHIDX  KSMCHDUR KSMCHCOM        KSMCHPTR           KSMCHSIZ KSMCHCLS  KSMCHTYP KSMCHPAR         BUCKETS KSMCHPTR_BEGIN   KSMCHPTR_END+1
---------------- ------- -------- ------ --------- --------- --------------- ---------------- ---------- -------- --------- ---------------- ------- ---------------- -----------------
00007F6035EE7C80  101105        1      1         1         1 row cache mutex 0000000077AD7C78    1572880 perm             0 0000000077004000   65536 0000000077AD7C78 0000000077C57C88
00007F6035EE7C18  101106        1      1         1         1 row cache hash  00000000779D7C68    1048592 perm             0 0000000077004000   65536 00000000779D7C68 0000000077AD7C78
00007F6035EE7BB0  101107        1      1         1         1 row cache       00000000779D7C50         24 perm             0 0000000077004000         00000000779D7C50 00000000779D7C68
00007F6035EE7B48  101108        1      1         1         1 row cache       00000000779D7C38         24 perm             0 0000000077004000         00000000779D7C38 00000000779D7C50
00007F6035EE7AE0  101109        1      1         1         1 row cache       00000000779D7C20         24 perm             0 0000000077004000         00000000779D7C20 00000000779D7C38
00007F6035EE7A78  101110        1      1         1         1 row cache       00000000779D7C08         24 perm             0 0000000077004000         00000000779D7C08 00000000779D7C20
00007F6035EE7A10  101111        1      1         1         1 row cache       00000000779D7BF0         24 perm             0 0000000077004000         00000000779D7BF0 00000000779D7C08
00007F6035EE79A8  101112        1      1         1         1 row cache       00000000779D7B60        144 perm             0 0000000077004000         00000000779D7B60 00000000779D7BF0
00007F6035EE7940  101113        1      1         1         1 row cache mutex 00000000779D7950        528 perm             0 0000000077004000     128 00000000779D7950 00000000779D7B60
00007F6035EE78D8  101114        1      1         1         1 row cache mutex 00000000779D6D40       3088 perm             0 0000000077004000     128 00000000779D6D40 00000000779D7950
00007F6035EE7870  101115        1      1         1         1 row cache hash  00000000779D6530       2064 perm             0 0000000077004000     128 00000000779D6530 00000000779D6D40
00007F6035EE7808  101116        1      1         1         1 row cache       00000000779D6518         24 perm             0 0000000077004000         00000000779D6518 00000000779D6530
00007F6035EE77A0  101117        1      1         1         1 row cache       00000000779D6500         24 perm             0 0000000077004000         00000000779D6500 00000000779D6518
00007F6035EE7738  101118        1      1         1         1 row cache       00000000779D64E8         24 perm             0 0000000077004000         00000000779D64E8 00000000779D6500
00007F6035EE76D0  101119        1      1         1         1 row cache       00000000779D64D0         24 perm             0 0000000077004000         00000000779D64D0 00000000779D64E8
00007F6035EE7668  101120        1      1         1         1 row cache       00000000779D64B8         24 perm             0 0000000077004000         00000000779D64B8 00000000779D64D0
00007F6035EE7600  101121        1      1         1         1 row cache       00000000779D6428        144 perm             0 0000000077004000         00000000779D6428 00000000779D64B8
00007F6035EE7598  101122        1      1         1         1 row cache mutex 00000000779D2418      16400 perm             0 0000000077004000    4096 00000000779D2418 00000000779D6428
00007F6035EE7530  101123        1      1         1         1 row cache mutex 00000000779BA408      98320 perm             0 0000000077004000    4096 00000000779BA408 00000000779D2418
00007F6035EE74C8  101124        1      1         1         1 row cache hash  00000000779AA3F8      65552 perm             0 0000000077004000    4096 00000000779AA3F8 00000000779BA408
00007F6035EE7460  101125        1      1         1         1 row cache       00000000779AA3E0         24 perm             0 0000000077004000         00000000779AA3E0 00000000779AA3F8
00007F6035EE73F8  101126        1      1         1         1 row cache       00000000779AA3C8         24 perm             0 0000000077004000         00000000779AA3C8 00000000779AA3E0
00007F6035EE7390  101127        1      1         1         1 row cache       00000000779AA3B0         24 perm             0 0000000077004000         00000000779AA3B0 00000000779AA3C8
00007F6035EE7328  101128        1      1         1         1 row cache       00000000779AA398         24 perm             0 0000000077004000         00000000779AA398 00000000779AA3B0
00007F6035EE72C0  101129        1      1         1         1 row cache       00000000779AA380         24 perm             0 0000000077004000         00000000779AA380 00000000779AA398
00007F6035EE7258  101130        1      1         1         1 row cache       00000000779AA2F0        144 perm             0 0000000077004000         00000000779AA2F0 00000000779AA380
00007F6035EE71F0  101131        1      1         1         1 row cache mutex 00000000779A9AE0       2064 perm             0 0000000077004000     512 00000000779A9AE0 00000000779AA2F0
00007F6035EE7188  101132        1      1         1         1 row cache mutex 00000000779A6AD0      12304 perm             0 0000000077004000     512 00000000779A6AD0 00000000779A9AE0
00007F6035EE7120  101133        1      1         1         1 row cache hash  00000000779A4AC0       8208 perm             0 0000000077004000     512 00000000779A4AC0 00000000779A6AD0
00007F6035EE70B8  101134        1      1         1         1 row cache       00000000779A4AA8         24 perm             0 0000000077004000         00000000779A4AA8 00000000779A4AC0
00007F6035EE7050  101135        1      1         1         1 row cache       00000000779A4A90         24 perm             0 0000000077004000         00000000779A4A90 00000000779A4AA8
00007F6035EE6FE8  101136        1      1         1         1 row cache       00000000779A4A78         24 perm             0 0000000077004000         00000000779A4A78 00000000779A4A90
00007F6035EE6F80  101137        1      1         1         1 row cache       00000000779A4A60         24 perm             0 0000000077004000         00000000779A4A60 00000000779A4A78
00007F6035EE6F18  101138        1      1         1         1 row cache       00000000779A4A48         24 perm             0 0000000077004000         00000000779A4A48 00000000779A4A60
00007F6035EE6EB0  101139        1      1         1         1 row cache       00000000779A49B8        144 perm             0 0000000077004000         00000000779A49B8 00000000779A4A48
00007F6035EE6E48  101140        1      1         1         1 row cache mutex 00000000779849A8     131088 perm             0 0000000077004000   32768 00000000779849A8 00000000779A49B8
00007F6035EE6DE0  101141        1      1         1         1 row cache mutex 00000000778C4998     786448 perm             0 0000000077004000   32768 00000000778C4998 00000000779849A8
00007F6035EE6D78  101142        1      1         1         1 row cache hash  0000000077844988     524304 perm             0 0000000077004000   32768 0000000077844988 00000000778C4998
00007F6035EE6D10  101143        1      1         1         1 row cache       0000000077844970         24 perm             0 0000000077004000         0000000077844970 0000000077844988
00007F6035EE6CA8  101144        1      1         1         1 row cache       0000000077844958         24 perm             0 0000000077004000         0000000077844958 0000000077844970
00007F6035EE6C40  101145        1      1         1         1 row cache       0000000077844940         24 perm             0 0000000077004000         0000000077844940 0000000077844958
00007F6035EE6BD8  101146        1      1         1         1 row cache       0000000077844928         24 perm             0 0000000077004000         0000000077844928 0000000077844940
00007F6035EE6B70  101147        1      1         1         1 row cache       0000000077844910         24 perm             0 0000000077004000         0000000077844910 0000000077844928
00007F6035EE6B08  101148        1      1         1         1 row cache       0000000077844880        144 perm             0 0000000077004000         0000000077844880 0000000077844910
00007F6035EE6AA0  101149        1      1         1         1 row cache mutex 0000000077824870     131088 perm             0 0000000077004000   32768 0000000077824870 0000000077844880
00007F6035EE6A38  101150        1      1         1         1 row cache mutex 0000000077764860     786448 perm             0 0000000077004000   32768 0000000077764860 0000000077824870
00007F6035EE69D0  101151        1      1         1         1 row cache hash  00000000776E4850     524304 perm             0 0000000077004000   32768 00000000776E4850 0000000077764860
00007F6035EE6968  101152        1      1         1         1 row cache       00000000776E4830         32 perm             0 0000000077004000         00000000776E4830 00000000776E4850
00007F6035EE6900  101153        1      1         1         1 row cache       00000000776E4818         24 perm             0 0000000077004000         00000000776E4818 00000000776E4830
00007F6035EE6898  101154        1      1         1         1 row cache       00000000776E4800         24 perm             0 0000000077004000         00000000776E4800 00000000776E4818
00007F6035EE6830  101155        1      1         1         1 row cache       00000000776E47E8         24 perm             0 0000000077004000         00000000776E47E8 00000000776E4800
00007F6035EE67C8  101156        1      1         1         1 row cache       00000000776E47D0         24 perm             0 0000000077004000         00000000776E47D0 00000000776E47E8
00007F6035EE6760  101157        1      1         1         1 row cache       00000000776E4740        144 perm             0 0000000077004000         00000000776E4740 00000000776E47D0
00007F6035EE66F8  101158        1      1         1         1 row cache mutex 00000000776E4630        272 perm             0 0000000077004000      64 00000000776E4630 00000000776E4740
00007F6035EE6690  101159        1      1         1         1 row cache mutex 00000000776E4020       1552 perm             0 0000000077004000      64 00000000776E4020 00000000776E4630
00007F6035EE6628  101160        1      1         1         1 row cache hash  00000000776E3C10       1040 perm             0 0000000077004000      64 00000000776E3C10 00000000776E4020
00007F6035EE65C0  101161        1      1         1         1 row cache       00000000776E3BF8         24 perm             0 0000000077004000         00000000776E3BF8 00000000776E3C10
00007F6035EE6558  101162        1      1         1         1 row cache       00000000776E3BE0         24 perm             0 0000000077004000         00000000776E3BE0 00000000776E3BF8
00007F6035EE64F0  101163        1      1         1         1 row cache       00000000776E3BC8         24 perm             0 0000000077004000         00000000776E3BC8 00000000776E3BE0
00007F6035EE6488  101164        1      1         1         1 row cache       00000000776E3BB0         24 perm             0 0000000077004000         00000000776E3BB0 00000000776E3BC8
00007F6035EE6420  101165        1      1         1         1 row cache       00000000776E3B98         24 perm             0 0000000077004000         00000000776E3B98 00000000776E3BB0
00007F6035EE63B8  101166        1      1         1         1 row cache       00000000776E3B08        144 perm             0 0000000077004000         00000000776E3B08 00000000776E3B98
00007F6035EE6350  101167        1      1         1         1 row cache mutex 00000000776E36F8       1040 perm             0 0000000077004000     256 00000000776E36F8 00000000776E3B08
00007F6035EE62E8  101168        1      1         1         1 row cache mutex 00000000776E1EE8       6160 perm             0 0000000077004000     256 00000000776E1EE8 00000000776E36F8
00007F6035EE6280  101169        1      1         1         1 row cache hash  00000000776E0ED8       4112 perm             0 0000000077004000     256 00000000776E0ED8 00000000776E1EE8
00007F6035EE6218  101170        1      1         1         1 row cache       00000000776E0EC0         24 perm             0 0000000077004000         00000000776E0EC0 00000000776E0ED8
00007F6035EE61B0  101171        1      1         1         1 row cache       00000000776E0EA8         24 perm             0 0000000077004000         00000000776E0EA8 00000000776E0EC0
00007F6035EE6148  101172        1      1         1         1 row cache       00000000776E0E90         24 perm             0 0000000077004000         00000000776E0E90 00000000776E0EA8
00007F6035EE60E0  101173        1      1         1         1 row cache       00000000776E0E78         24 perm             0 0000000077004000         00000000776E0E78 00000000776E0E90
00007F6035EE6078  101174        1      1         1         1 row cache       00000000776E0E60         24 perm             0 0000000077004000         00000000776E0E60 00000000776E0E78
00007F6035EE6010  101175        1      1         1         1 row cache       00000000776E0DD0        144 perm             0 0000000077004000         00000000776E0DD0 00000000776E0E60
00007F6035EE5FA8  101176        1      1         1         1 row cache mutex 00000000776E0D40        144 perm             0 0000000077004000      32 00000000776E0D40 00000000776E0DD0
00007F6035EE5F40  101177        1      1         1         1 row cache mutex 00000000776E0A30        784 perm             0 0000000077004000      32 00000000776E0A30 00000000776E0D40
00007F6035EE5ED8  101178        1      1         1         1 row cache hash  00000000776E0820        528 perm             0 0000000077004000      32 00000000776E0820 00000000776E0A30
00007F6035EE5E70  101179        1      1         1         1 row cache       00000000776E0808         24 perm             0 0000000077004000         00000000776E0808 00000000776E0820
00007F6035EE5E08  101180        1      1         1         1 row cache       00000000776E07F0         24 perm             0 0000000077004000         00000000776E07F0 00000000776E0808
00007F6035EE5DA0  101181        1      1         1         1 row cache       00000000776E07D8         24 perm             0 0000000077004000         00000000776E07D8 00000000776E07F0
00007F6035EE5D38  101182        1      1         1         1 row cache       00000000776E07C0         24 perm             0 0000000077004000         00000000776E07C0 00000000776E07D8
00007F6035EE5CD0  101183        1      1         1         1 row cache       00000000776E07A8         24 perm             0 0000000077004000         00000000776E07A8 00000000776E07C0
00007F6035EE5C68  101184        1      1         1         1 row cache       00000000776E0718        144 perm             0 0000000077004000         00000000776E0718 00000000776E07A8
00007F6035EE5C00  101185        1      1         1         1 row cache mutex 00000000776C0708     131088 perm             0 0000000077004000   32768 00000000776C0708 00000000776E0718
00007F6035EE5B98  101186        1      1         1         1 row cache mutex 00000000776006F8     786448 perm             0 0000000077004000   32768 00000000776006F8 00000000776C0708
00007F6035EE5B30  101187        1      1         1         1 row cache hash  00000000775806E8     524304 perm             0 0000000077004000   32768 00000000775806E8 00000000776006F8
00007F6035EE5AC8  101188        1      1         1         1 row cache       00000000775806D0         24 perm             0 0000000077004000         00000000775806D0 00000000775806E8
00007F6035EE5A60  101189        1      1         1         1 row cache       00000000775806B8         24 perm             0 0000000077004000         00000000775806B8 00000000775806D0
00007F6035EE59F8  101190        1      1         1         1 row cache       00000000775806A0         24 perm             0 0000000077004000         00000000775806A0 00000000775806B8
00007F6035EE5990  101191        1      1         1         1 row cache       0000000077580688         24 perm             0 0000000077004000         0000000077580688 00000000775806A0
00007F6035EE5928  101192        1      1         1         1 row cache       0000000077580670         24 perm             0 0000000077004000         0000000077580670 0000000077580688
00007F6035EE58C0  101193        1      1         1         1 row cache       00000000775805E0        144 perm             0 0000000077004000         00000000775805E0 0000000077580670
00007F6035EE5858  101194        1      1         1         1 row cache mutex 00000000775801D0       1040 perm             0 0000000077004000     256 00000000775801D0 00000000775805E0
00007F6035EE57F0  101195        1      1         1         1 row cache mutex 000000007757E9C0       6160 perm             0 0000000077004000     256 000000007757E9C0 00000000775801D0
00007F6035EE5788  101196        1      1         1         1 row cache hash  000000007757D9B0       4112 perm             0 0000000077004000     256 000000007757D9B0 000000007757E9C0
00007F6035EE5720  101197        1      1         1         1 row cache       000000007757D998         24 perm             0 0000000077004000         000000007757D998 000000007757D9B0
00007F6035EE56B8  101198        1      1         1         1 row cache       000000007757D980         24 perm             0 0000000077004000         000000007757D980 000000007757D998
00007F6035EE5650  101199        1      1         1         1 row cache       000000007757D968         24 perm             0 0000000077004000         000000007757D968 000000007757D980
00007F6035EE55E8  101200        1      1         1         1 row cache       000000007757D950         24 perm             0 0000000077004000         000000007757D950 000000007757D968
00007F6035EE5580  101201        1      1         1         1 row cache       000000007757D938         24 perm             0 0000000077004000         000000007757D938 000000007757D950
00007F6035EE5518  101202        1      1         1         1 row cache       000000007757D8A8        144 perm             0 0000000077004000         000000007757D8A8 000000007757D938
00007F6035EE54B0  101203        1      1         1         1 row cache mutex 000000007757D498       1040 perm             0 0000000077004000     256 000000007757D498 000000007757D8A8
00007F6035EE5448  101204        1      1         1         1 row cache mutex 000000007757BC88       6160 perm             0 0000000077004000     256 000000007757BC88 000000007757D498
00007F6035EE53E0  101205        1      1         1         1 row cache hash  000000007757AC78       4112 perm             0 0000000077004000     256 000000007757AC78 000000007757BC88
00007F6035EE5378  101206        1      1         1         1 row cache       000000007757AC60         24 perm             0 0000000077004000         000000007757AC60 000000007757AC78
00007F6035EE5310  101207        1      1         1         1 row cache       000000007757AC48         24 perm             0 0000000077004000         000000007757AC48 000000007757AC60
00007F6035EE52A8  101208        1      1         1         1 row cache       000000007757AC30         24 perm             0 0000000077004000         000000007757AC30 000000007757AC48
00007F6035EE5240  101209        1      1         1         1 row cache       000000007757AC18         24 perm             0 0000000077004000         000000007757AC18 000000007757AC30
00007F6035EE51D8  101210        1      1         1         1 row cache       000000007757AC00         24 perm             0 0000000077004000         000000007757AC00 000000007757AC18
00007F6035EE5170  101211        1      1         1         1 row cache       000000007757AB70        144 perm             0 0000000077004000         000000007757AB70 000000007757AC00
00007F6035EE5108  101212        1      1         1         1 row cache mutex 000000007756AB60      65552 perm             0 0000000077004000   16384 000000007756AB60 000000007757AB70
00007F6035EE50A0  101213        1      1         1         1 row cache mutex 000000007750AB50     393232 perm             0 0000000077004000   16384 000000007750AB50 000000007756AB60
00007F6035EE5038  101214        1      1         1         1 row cache hash  00000000774CAB40     262160 perm             0 0000000077004000   16384 00000000774CAB40 000000007750AB50
00007F6035EE4FD0  101215        1      1         1         1 row cache       00000000774CAB28         24 perm             0 0000000077004000         00000000774CAB28 00000000774CAB40
00007F6035EE4F68  101216        1      1         1         1 row cache       00000000774CAB10         24 perm             0 0000000077004000         00000000774CAB10 00000000774CAB28
00007F6035EE4F00  101217        1      1         1         1 row cache       00000000774CAAF8         24 perm             0 0000000077004000         00000000774CAAF8 00000000774CAB10
00007F6035EE4E98  101218        1      1         1         1 row cache       00000000774CAAE0         24 perm             0 0000000077004000         00000000774CAAE0 00000000774CAAF8
00007F6035EE4E30  101219        1      1         1         1 row cache       00000000774CAAC8         24 perm             0 0000000077004000         00000000774CAAC8 00000000774CAAE0
00007F6035EE4DC8  101220        1      1         1         1 row cache       00000000774CAA38        144 perm             0 0000000077004000         00000000774CAA38 00000000774CAAC8
--//地址出现跳跃,两者的KSMCHPAR不同。使用fchaz 查询@ fchaz 0000000076081000,@ fchaz 0000000077004000,没有记录返回的。
00007F6035EC12E0  102623        1      1         1         1 row cache       0000000076A46BA8         24 perm             0 0000000076081000         0000000076A46BA8 0000000076A46BC0
00007F6035EC1278  102624        1      1         1         1 row cache       0000000076A46B88         32 perm             0 0000000076081000         0000000076A46B88 0000000076A46BA8
00007F6035EC1210  102625        1      1         1         1 row cache       0000000076A46B70         24 perm             0 0000000076081000         0000000076A46B70 0000000076A46B88
00007F6035EC11A8  102626        1      1         1         1 row cache       0000000076A46B50         32 perm             0 0000000076081000         0000000076A46B50 0000000076A46B70
00007F6035EC1140  102627        1      1         1         1 row cache       0000000076A46B30         32 perm             0 0000000076081000         0000000076A46B30 0000000076A46B50
00007F6035EC10D8  102628        1      1         1         1 row cache       0000000076A46B18         24 perm             0 0000000076081000         0000000076A46B18 0000000076A46B30
00007F6035EC1008  102630        1      1         1         1 row cache mutex 0000000076A469C8        272 perm             0 0000000076081000      64 0000000076A469C8 0000000076A46AD8 --//0000000076A46AD8 - 0000000076A46B18 有1个64字节的chunk。
00007F6035EC0FA0  102631        1      1         1         1 row cache mutex 0000000076A463B8       1552 perm             0 0000000076081000      64 0000000076A463B8 0000000076A469C8
00007F6035EC0F38  102632        1      1         1         1 row cache hash  0000000076A45FA8       1040 perm             0 0000000076081000      64 0000000076A45FA8 0000000076A463B8
00007F6035EC0ED0  102633        1      1         1         1 row cache       0000000076A45F90         24 perm             0 0000000076081000         0000000076A45F90 0000000076A45FA8
00007F6035EC0E68  102634        1      1         1         1 row cache       0000000076A45F78         24 perm             0 0000000076081000         0000000076A45F78 0000000076A45F90
00007F6035EC0E00  102635        1      1         1         1 row cache       0000000076A45F60         24 perm             0 0000000076081000         0000000076A45F60 0000000076A45F78
00007F6035EC0D98  102636        1      1         1         1 row cache       0000000076A45F48         24 perm             0 0000000076081000         0000000076A45F48 0000000076A45F60
00007F6035EC0D30  102637        1      1         1         1 row cache       0000000076A45F30         24 perm             0 0000000076081000         0000000076A45F30 0000000076A45F48
00007F6035EC0CC8  102638        1      1         1         1 row cache       0000000076A45EA0        144 perm             0 0000000076081000         0000000076A45EA0 0000000076A45F30
00007F6035EC0C60  102639        1      1         1         1 row cache mutex 0000000076A45D90        272 perm             0 0000000076081000      64 0000000076A45D90 0000000076A45EA0
00007F6035EC0BF8  102640        1      1         1         1 row cache mutex 0000000076A45780       1552 perm             0 0000000076081000      64 0000000076A45780 0000000076A45D90
00007F6035EC0B90  102641        1      1         1         1 row cache hash  0000000076A45370       1040 perm             0 0000000076081000      64 0000000076A45370 0000000076A45780
00007F6035EC0B28  102642        1      1         1         1 row cache       0000000076A45358         24 perm             0 0000000076081000         0000000076A45358 0000000076A45370
00007F6035EC0AC0  102643        1      1         1         1 row cache       0000000076A45340         24 perm             0 0000000076081000         0000000076A45340 0000000076A45358
00007F6035EC0A58  102644        1      1         1         1 row cache       0000000076A45328         24 perm             0 0000000076081000         0000000076A45328 0000000076A45340
00007F6035EC09F0  102645        1      1         1         1 row cache       0000000076A45310         24 perm             0 0000000076081000         0000000076A45310 0000000076A45328
00007F6035EC0988  102646        1      1         1         1 row cache       0000000076A452F8         24 perm             0 0000000076081000         0000000076A452F8 0000000076A45310
00007F6035EC0920  102647        1      1         1         1 row cache       0000000076A45268        144 perm             0 0000000076081000         0000000076A45268 0000000076A452F8
00007F6035EC08B8  102648        1      1         1         1 row cache mutex 0000000076A45158        272 perm             0 0000000076081000      64 0000000076A45158 0000000076A45268
00007F6035EC0850  102649        1      1         1         1 row cache mutex 0000000076A44B48       1552 perm             0 0000000076081000      64 0000000076A44B48 0000000076A45158
00007F6035EC07E8  102650        1      1         1         1 row cache hash  0000000076A44738       1040 perm             0 0000000076081000      64 0000000076A44738 0000000076A44B48
00007F6035EC0780  102651        1      1         1         1 row cache       0000000076A44720         24 perm             0 0000000076081000         0000000076A44720 0000000076A44738
00007F6035EC0718  102652        1      1         1         1 row cache       0000000076A44708         24 perm             0 0000000076081000         0000000076A44708 0000000076A44720
00007F6035EC06B0  102653        1      1         1         1 row cache       0000000076A446F0         24 perm             0 0000000076081000         0000000076A446F0 0000000076A44708
00007F6035EC0648  102654        1      1         1         1 row cache       0000000076A446D8         24 perm             0 0000000076081000         0000000076A446D8 0000000076A446F0
00007F6035EC05E0  102655        1      1         1         1 row cache       0000000076A446C0         24 perm             0 0000000076081000         0000000076A446C0 0000000076A446D8
00007F6035EC0578  102656        1      1         1         1 row cache       0000000076A44630        144 perm             0 0000000076081000         0000000076A44630 0000000076A446C0
00007F6035EC0510  102657        1      1         1         1 row cache mutex 0000000076A44520        272 perm             0 0000000076081000      64 0000000076A44520 0000000076A44630
00007F6035EC04A8  102658        1      1         1         1 row cache mutex 0000000076A43F10       1552 perm             0 0000000076081000      64 0000000076A43F10 0000000076A44520
00007F6035EC0440  102659        1      1         1         1 row cache hash  0000000076A43B00       1040 perm             0 0000000076081000      64 0000000076A43B00 0000000076A43F10
00007F6035EC03D8  102660        1      1         1         1 row cache       0000000076A43AE8         24 perm             0 0000000076081000         0000000076A43AE8 0000000076A43B00
00007F6035EC0370  102661        1      1         1         1 row cache       0000000076A43AD0         24 perm             0 0000000076081000         0000000076A43AD0 0000000076A43AE8
00007F6035EC0308  102662        1      1         1         1 row cache       0000000076A43AB8         24 perm             0 0000000076081000         0000000076A43AB8 0000000076A43AD0
00007F6035EC02A0  102663        1      1         1         1 row cache       0000000076A43AA0         24 perm             0 0000000076081000         0000000076A43AA0 0000000076A43AB8
00007F6035EC0238  102664        1      1         1         1 row cache       0000000076A43A88         24 perm             0 0000000076081000         0000000076A43A88 0000000076A43AA0
00007F6035EC01D0  102665        1      1         1         1 row cache       0000000076A439F8        144 perm             0 0000000076081000         0000000076A439F8 0000000076A43A88
00007F6035EC0168  102666        1      1         1         1 row cache mutex 0000000076A435E8       1040 perm             0 0000000076081000     256 0000000076A435E8 0000000076A439F8
00007F6035EC0100  102667        1      1         1         1 row cache mutex 0000000076A41DD8       6160 perm             0 0000000076081000     256 0000000076A41DD8 0000000076A435E8
00007F6035EC0098  102668        1      1         1         1 row cache hash  0000000076A40DC8       4112 perm             0 0000000076081000     256 0000000076A40DC8 0000000076A41DD8
00007F6035EC0030  102669        1      1         1         1 row cache       0000000076A40DB0         24 perm             0 0000000076081000         0000000076A40DB0 0000000076A40DC8
00007F6035EBFFC8  102670        1      1         1         1 row cache       0000000076A40D98         24 perm             0 0000000076081000         0000000076A40D98 0000000076A40DB0
00007F6035EBFF60  102671        1      1         1         1 row cache       0000000076A40D80         24 perm             0 0000000076081000         0000000076A40D80 0000000076A40D98
00007F6035EBFEF8  102672        1      1         1         1 row cache       0000000076A40D68         24 perm             0 0000000076081000         0000000076A40D68 0000000076A40D80
00007F6035EBFE90  102673        1      1         1         1 row cache       0000000076A40D50         24 perm             0 0000000076081000         0000000076A40D50 0000000076A40D68
00007F6035EBFE28  102674        1      1         1         1 row cache       0000000076A40CC0        144 perm             0 0000000076081000         0000000076A40CC0 0000000076A40D50
00007F6035EBFDC0  102675        1      1         1         1 row cache mutex 0000000076A408B0       1040 perm             0 0000000076081000     256 0000000076A408B0 0000000076A40CC0
00007F6035EBFD58  102676        1      1         1         1 row cache mutex 0000000076A3F0A0       6160 perm             0 0000000076081000     256 0000000076A3F0A0 0000000076A408B0
00007F6035EBFCF0  102677        1      1         1         1 row cache hash  0000000076A3E090       4112 perm             0 0000000076081000     256 0000000076A3E090 0000000076A3F0A0
00007F6035EBFC88  102678        1      1         1         1 row cache       0000000076A3E078         24 perm             0 0000000076081000         0000000076A3E078 0000000076A3E090
00007F6035EBFC20  102679        1      1         1         1 row cache       0000000076A3E060         24 perm             0 0000000076081000         0000000076A3E060 0000000076A3E078
00007F6035EBFBB8  102680        1      1         1         1 row cache       0000000076A3E048         24 perm             0 0000000076081000         0000000076A3E048 0000000076A3E060
00007F6035EBFB50  102681        1      1         1         1 row cache       0000000076A3E030         24 perm             0 0000000076081000         0000000076A3E030 0000000076A3E048
00007F6035EBFAE8  102682        1      1         1         1 row cache       0000000076A3E018         24 perm             0 0000000076081000         0000000076A3E018 0000000076A3E030
00007F6035EBFA80  102683        1      1         1         1 row cache       0000000076A3DF88        144 perm             0 0000000076081000         0000000076A3DF88 0000000076A3E018
00007F6035EBFA18  102684        1      1         1         1 row cache mutex 0000000076A3D778       2064 perm             0 0000000076081000     512 0000000076A3D778 0000000076A3DF88
00007F6035EBF9B0  102685        1      1         1         1 row cache mutex 0000000076A3A768      12304 perm             0 0000000076081000     512 0000000076A3A768 0000000076A3D778
00007F6035EBF948  102686        1      1         1         1 row cache hash  0000000076A38758       8208 perm             0 0000000076081000     512 0000000076A38758 0000000076A3A768
00007F6035EBF8E0  102687        1      1         1         1 row cache       0000000076A38740         24 perm             0 0000000076081000         0000000076A38740 0000000076A38758
00007F6035EBF878  102688        1      1         1         1 row cache       0000000076A38728         24 perm             0 0000000076081000         0000000076A38728 0000000076A38740
00007F6035EBF810  102689        1      1         1         1 row cache       0000000076A38710         24 perm             0 0000000076081000         0000000076A38710 0000000076A38728
00007F6035EBF7A8  102690        1      1         1         1 row cache       0000000076A386F8         24 perm             0 0000000076081000         0000000076A386F8 0000000076A38710
00007F6035EBF740  102691        1      1         1         1 row cache       0000000076A386E0         24 perm             0 0000000076081000         0000000076A386E0 0000000076A386F8
00007F6035EBF6D8  102692        1      1         1         1 row cache       0000000076A38650        144 perm             0 0000000076081000         0000000076A38650 0000000076A386E0
00007F6035EBF670  102693        1      1         1         1 row cache mutex 0000000076A38638         24 perm             0 0000000076081000       2 0000000076A38638 0000000076A38650
00007F6035EBF608  102694        1      1         1         1 row cache mutex 0000000076A38610         40 perm             0 0000000076081000       1 0000000076A38610 0000000076A38638
00007F6035EBF5A0  102695        1      1         1         1 row cache hash  0000000076A385F0         32 perm             0 0000000076081000       1 0000000076A385F0 0000000076A38610
00007F6035EBF538  102696        1      1         1         1 row cache       0000000076A385D8         24 perm             0 0000000076081000         0000000076A385D8 0000000076A385F0
00007F6035EBF4D0  102697        1      1         1         1 row cache       0000000076A385C0         24 perm             0 0000000076081000         0000000076A385C0 0000000076A385D8
00007F6035EBF468  102698        1      1         1         1 row cache       0000000076A385A8         24 perm             0 0000000076081000         0000000076A385A8 0000000076A385C0
00007F6035EBF400  102699        1      1         1         1 row cache       0000000076A38590         24 perm             0 0000000076081000         0000000076A38590 0000000076A385A8
00007F6035EBF398  102700        1      1         1         1 row cache       0000000076A38578         24 perm             0 0000000076081000         0000000076A38578 0000000076A38590
00007F6035EBF330  102701        1      1         1         1 row cache       0000000076A384E8        144 perm             0 0000000076081000         0000000076A384E8 0000000076A38578
00007F6035EBF2C8  102702        1      1         1         1 row cache mutex 0000000076A380D8       1040 perm             0 0000000076081000     256 0000000076A380D8 0000000076A384E8
00007F6035EBF260  102703        1      1         1         1 row cache mutex 0000000076A368C8       6160 perm             0 0000000076081000     256 0000000076A368C8 0000000076A380D8
00007F6035EBF1F8  102704        1      1         1         1 row cache hash  0000000076A358B8       4112 perm             0 0000000076081000     256 0000000076A358B8 0000000076A368C8
00007F6035EBF190  102705        1      1         1         1 row cache       0000000076A358A0         24 perm             0 0000000076081000         0000000076A358A0 0000000076A358B8
00007F6035EBF128  102706        1      1         1         1 row cache       0000000076A35888         24 perm             0 0000000076081000         0000000076A35888 0000000076A358A0
00007F6035EBF0C0  102707        1      1         1         1 row cache       0000000076A35870         24 perm             0 0000000076081000         0000000076A35870 0000000076A35888
00007F6035EBF058  102708        1      1         1         1 row cache       0000000076A35858         24 perm             0 0000000076081000         0000000076A35858 0000000076A35870
00007F6035EBEFF0  102709        1      1         1         1 row cache       0000000076A35840         24 perm             0 0000000076081000         0000000076A35840 0000000076A35858
00007F6035EBEF88  102710        1      1         1         1 row cache       0000000076A357B0        144 perm             0 0000000076081000         0000000076A357B0 0000000076A35840
00007F6035EBEF20  102711        1      1         1         1 row cache mutex 0000000076A34FA0       2064 perm             0 0000000076081000     512 0000000076A34FA0 0000000076A357B0
00007F6035EBEEB8  102712        1      1         1         1 row cache mutex 0000000076A31F90      12304 perm             0 0000000076081000     512 0000000076A31F90 0000000076A34FA0
00007F6035EBEE50  102713        1      1         1         1 row cache hash  0000000076A2FF80       8208 perm             0 0000000076081000     512 0000000076A2FF80 0000000076A31F90
00007F6035EBEDE8  102714        1      1         1         1 row cache       0000000076A2FF68         24 perm             0 0000000076081000         0000000076A2FF68 0000000076A2FF80
00007F6035EBED80  102715        1      1         1         1 row cache       0000000076A2FF50         24 perm             0 0000000076081000         0000000076A2FF50 0000000076A2FF68
00007F6035EBED18  102716        1      1         1         1 row cache       0000000076A2FF38         24 perm             0 0000000076081000         0000000076A2FF38 0000000076A2FF50
00007F6035EBECB0  102717        1      1         1         1 row cache       0000000076A2FF20         24 perm             0 0000000076081000         0000000076A2FF20 0000000076A2FF38
00007F6035EBEC48  102718        1      1         1         1 row cache       0000000076A2FF08         24 perm             0 0000000076081000         0000000076A2FF08 0000000076A2FF20
00007F6035EBEBE0  102719        1      1         1         1 row cache       0000000076A2FE78        144 perm             0 0000000076081000         0000000076A2FE78 0000000076A2FF08
00007F6035EBEB78  102720        1      1         1         1 row cache mutex 0000000076A2FC68        528 perm             0 0000000076081000     128 0000000076A2FC68 0000000076A2FE78
00007F6035EBEB10  102721        1      1         1         1 row cache mutex 0000000076A2F058       3088 perm             0 0000000076081000     128 0000000076A2F058 0000000076A2FC68
00007F6035EBEAA8  102722        1      1         1         1 row cache hash  0000000076A2E848       2064 perm             0 0000000076081000     128 0000000076A2E848 0000000076A2F058
00007F6035EBEA40  102723        1      1         1         1 row cache       0000000076A2E830         24 perm             0 0000000076081000         0000000076A2E830 0000000076A2E848
00007F6035EBE9D8  102724        1      1         1         1 row cache       0000000076A2E818         24 perm             0 0000000076081000         0000000076A2E818 0000000076A2E830
00007F6035EBE970  102725        1      1         1         1 row cache       0000000076A2E800         24 perm             0 0000000076081000         0000000076A2E800 0000000076A2E818
00007F6035EBE908  102726        1      1         1         1 row cache       0000000076A2E7E8         24 perm             0 0000000076081000         0000000076A2E7E8 0000000076A2E800
00007F6035EBE8A0  102727        1      1         1         1 row cache       0000000076A2E7D0         24 perm             0 0000000076081000         0000000076A2E7D0 0000000076A2E7E8
00007F6035EBE838  102728        1      1         1         1 row cache       0000000076A2E740        144 perm             0 0000000076081000         0000000076A2E740 0000000076A2E7D0
00007F6035EBE7D0  102729        1      1         1         1 row cache mutex 0000000076A2DF30       2064 perm             0 0000000076081000     512 0000000076A2DF30 0000000076A2E740
00007F6035EBE768  102730        1      1         1         1 row cache mutex 0000000076A2AF20      12304 perm             0 0000000076081000     512 0000000076A2AF20 0000000076A2DF30
00007F6035EBE700  102731        1      1         1         1 row cache hash  0000000076A28F10       8208 perm             0 0000000076081000     512 0000000076A28F10 0000000076A2AF20
00007F6035EBE698  102732        1      1         1         1 row cache       0000000076A28EF8         24 perm             0 0000000076081000         0000000076A28EF8 0000000076A28F10
00007F6035EBE630  102733        1      1         1         1 row cache       0000000076A28EE0         24 perm             0 0000000076081000         0000000076A28EE0 0000000076A28EF8
00007F6035EBE5C8  102734        1      1         1         1 row cache       0000000076A28EC8         24 perm             0 0000000076081000         0000000076A28EC8 0000000076A28EE0
00007F6035EBE560  102735        1      1         1         1 row cache       0000000076A28EB0         24 perm             0 0000000076081000         0000000076A28EB0 0000000076A28EC8
00007F6035EBE4F8  102736        1      1         1         1 row cache       0000000076A28E98         24 perm             0 0000000076081000         0000000076A28E98 0000000076A28EB0
00007F6035EBE490  102737        1      1         1         1 row cache       0000000076A28E08        144 perm             0 0000000076081000         0000000076A28E08 0000000076A28E98
00007F6035EBE428  102738        1      1         1         1 row cache mutex 0000000076A285F8       2064 perm             0 0000000076081000     512 0000000076A285F8 0000000076A28E08
00007F6035EBE3C0  102739        1      1         1         1 row cache mutex 0000000076A255E8      12304 perm             0 0000000076081000     512 0000000076A255E8 0000000076A285F8
00007F6035EBE358  102740        1      1         1         1 row cache hash  0000000076A235D8       8208 perm             0 0000000076081000     512 0000000076A235D8 0000000076A255E8
00007F6035EBE2F0  102741        1      1         1         1 row cache       0000000076A235C0         24 perm             0 0000000076081000         0000000076A235C0 0000000076A235D8
00007F6035EBE288  102742        1      1         1         1 row cache       0000000076A235A8         24 perm             0 0000000076081000         0000000076A235A8 0000000076A235C0
00007F6035EBE220  102743        1      1         1         1 row cache       0000000076A23590         24 perm             0 0000000076081000         0000000076A23590 0000000076A235A8
00007F6035EBE1B8  102744        1      1         1         1 row cache       0000000076A23578         24 perm             0 0000000076081000         0000000076A23578 0000000076A23590
00007F6035EBE150  102745        1      1         1         1 row cache       0000000076A23560         24 perm             0 0000000076081000         0000000076A23560 0000000076A23578
00007F6035EBE0E8  102746        1      1         1         1 row cache       0000000076A234D0        144 perm             0 0000000076081000         0000000076A234D0 0000000076A23560
00007F6035EBE080  102747        1      1         1         1 row cache mutex 0000000076A22CC0       2064 perm             0 0000000076081000     512 0000000076A22CC0 0000000076A234D0
00007F6035EBE018  102748        1      1         1         1 row cache mutex 0000000076A1FCB0      12304 perm             0 0000000076081000     512 0000000076A1FCB0 0000000076A22CC0
00007F6035EBDFB0  102749        1      1         1         1 row cache hash  0000000076A1DCA0       8208 perm             0 0000000076081000     512 0000000076A1DCA0 0000000076A1FCB0
00007F6035EBDF48  102750        1      1         1         1 row cache       0000000076A1DC88         24 perm             0 0000000076081000         0000000076A1DC88 0000000076A1DCA0
00007F6035EBDEE0  102751        1      1         1         1 row cache       0000000076A1DC70         24 perm             0 0000000076081000         0000000076A1DC70 0000000076A1DC88
00007F6035EBDE78  102752        1      1         1         1 row cache       0000000076A1DC58         24 perm             0 0000000076081000         0000000076A1DC58 0000000076A1DC70
00007F6035EBDE10  102753        1      1         1         1 row cache       0000000076A1DC40         24 perm             0 0000000076081000         0000000076A1DC40 0000000076A1DC58
00007F6035EBDDA8  102754        1      1         1         1 row cache       0000000076A1DC28         24 perm             0 0000000076081000         0000000076A1DC28 0000000076A1DC40
00007F6035EBDD40  102755        1      1         1         1 row cache       0000000076A1DB98        144 perm             0 0000000076081000         0000000076A1DB98 0000000076A1DC28
00007F6035EBDCD8  102756        1      1         1         1 row cache mutex 0000000076A1D388       2064 perm             0 0000000076081000     512 0000000076A1D388 0000000076A1DB98
00007F6035EBDC70  102757        1      1         1         1 row cache mutex 0000000076A1A378      12304 perm             0 0000000076081000     512 0000000076A1A378 0000000076A1D388
00007F6035EBDC08  102758        1      1         1         1 row cache hash  0000000076A18368       8208 perm             0 0000000076081000     512 0000000076A18368 0000000076A1A378
00007F6035EBDBA0  102759        1      1         1         1 row cache       0000000076A18350         24 perm             0 0000000076081000         0000000076A18350 0000000076A18368
00007F6035EBDB38  102760        1      1         1         1 row cache       0000000076A18338         24 perm             0 0000000076081000         0000000076A18338 0000000076A18350
00007F6035EBDAD0  102761        1      1         1         1 row cache       0000000076A18320         24 perm             0 0000000076081000         0000000076A18320 0000000076A18338
00007F6035EBDA68  102762        1      1         1         1 row cache       0000000076A18308         24 perm             0 0000000076081000         0000000076A18308 0000000076A18320
00007F6035EBDA00  102763        1      1         1         1 row cache       0000000076A182F0         24 perm             0 0000000076081000         0000000076A182F0 0000000076A18308
00007F6035EBD998  102764        1      1         1         1 row cache       0000000076A18260        144 perm             0 0000000076081000         0000000076A18260 0000000076A182F0
00007F6035EBD930  102765        1      1         1         1 row cache mutex 0000000076A17A50       2064 perm             0 0000000076081000     512 0000000076A17A50 0000000076A18260
00007F6035EBD8C8  102766        1      1         1         1 row cache mutex 0000000076A14A40      12304 perm             0 0000000076081000     512 0000000076A14A40 0000000076A17A50
00007F6035EBD860  102767        1      1         1         1 row cache hash  0000000076A12A30       8208 perm             0 0000000076081000     512 0000000076A12A30 0000000076A14A40
00007F6035EBD7F8  102768        1      1         1         1 row cache       0000000076A12A18         24 perm             0 0000000076081000         0000000076A12A18 0000000076A12A30
00007F6035EBD790  102769        1      1         1         1 row cache       0000000076A12A00         24 perm             0 0000000076081000         0000000076A12A00 0000000076A12A18
00007F6035EBD728  102770        1      1         1         1 row cache       0000000076A129E8         24 perm             0 0000000076081000         0000000076A129E8 0000000076A12A00
00007F6035EBD6C0  102771        1      1         1         1 row cache       0000000076A129D0         24 perm             0 0000000076081000         0000000076A129D0 0000000076A129E8
00007F6035EBD658  102772        1      1         1         1 row cache       0000000076A129B8         24 perm             0 0000000076081000         0000000076A129B8 0000000076A129D0
00007F6035EBD5F0  102773        1      1         1         1 row cache       0000000076A12928        144 perm             0 0000000076081000         0000000076A12928 0000000076A129B8
00007F6035EBD588  102774        1      1         1         1 row cache mutex 0000000076A12118       2064 perm             0 0000000076081000     512 0000000076A12118 0000000076A12928
00007F6035EBD520  102775        1      1         1         1 row cache mutex 0000000076A0F108      12304 perm             0 0000000076081000     512 0000000076A0F108 0000000076A12118
00007F6035EBD4B8  102776        1      1         1         1 row cache hash  0000000076A0D0F8       8208 perm             0 0000000076081000     512 0000000076A0D0F8 0000000076A0F108
00007F6035EBD450  102777        1      1         1         1 row cache       0000000076A0D0E0         24 perm             0 0000000076081000         0000000076A0D0E0 0000000076A0D0F8
00007F6035EBD3E8  102778        1      1         1         1 row cache       0000000076A0D0C8         24 perm             0 0000000076081000         0000000076A0D0C8 0000000076A0D0E0
00007F6035EBD380  102779        1      1         1         1 row cache       0000000076A0D0B0         24 perm             0 0000000076081000         0000000076A0D0B0 0000000076A0D0C8
00007F6035EBD318  102780        1      1         1         1 row cache       0000000076A0D098         24 perm             0 0000000076081000         0000000076A0D098 0000000076A0D0B0
00007F6035EBD2B0  102781        1      1         1         1 row cache       0000000076A0D080         24 perm             0 0000000076081000         0000000076A0D080 0000000076A0D098
00007F6035EBD248  102782        1      1         1         1 row cache       0000000076A0CFF0        144 perm             0 0000000076081000         0000000076A0CFF0 0000000076A0D080
00007F6035EBD1E0  102783        1      1         1         1 row cache mutex 0000000076A0C7E0       2064 perm             0 0000000076081000     512 0000000076A0C7E0 0000000076A0CFF0
00007F6035EBD178  102784        1      1         1         1 row cache mutex 0000000076A097D0      12304 perm             0 0000000076081000     512 0000000076A097D0 0000000076A0C7E0
00007F6035EBD110  102785        1      1         1         1 row cache hash  0000000076A077C0       8208 perm             0 0000000076081000     512 0000000076A077C0 0000000076A097D0
00007F6035EBD0A8  102786        1      1         1         1 row cache       0000000076A077A8         24 perm             0 0000000076081000         0000000076A077A8 0000000076A077C0
00007F6035EBD040  102787        1      1         1         1 row cache       0000000076A07790         24 perm             0 0000000076081000         0000000076A07790 0000000076A077A8
00007F6035EBCFD8  102788        1      1         1         1 row cache       0000000076A07778         24 perm             0 0000000076081000         0000000076A07778 0000000076A07790
00007F6035EBCF70  102789        1      1         1         1 row cache       0000000076A07760         24 perm             0 0000000076081000         0000000076A07760 0000000076A07778
00007F6035EBCF08  102790        1      1         1         1 row cache       0000000076A07748         24 perm             0 0000000076081000         0000000076A07748 0000000076A07760
00007F6035EBCEA0  102791        1      1         1         1 row cache       0000000076A076B8        144 perm             0 0000000076081000         0000000076A076B8 0000000076A07748
00007F6035EBCE38  102792        1      1         1         1 row cache mutex 0000000076A06EA8       2064 perm             0 0000000076081000     512 0000000076A06EA8 0000000076A076B8
00007F6035EBCDD0  102793        1      1         1         1 row cache mutex 0000000076A03E98      12304 perm             0 0000000076081000     512 0000000076A03E98 0000000076A06EA8
00007F6035EBCD68  102794        1      1         1         1 row cache hash  0000000076A01E88       8208 perm             0 0000000076081000     512 0000000076A01E88 0000000076A03E98
00007F6035EBCD00  102795        1      1         1         1 row cache       0000000076A01E70         24 perm             0 0000000076081000         0000000076A01E70 0000000076A01E88
00007F6035EBCC98  102796        1      1         1         1 row cache       0000000076A01E58         24 perm             0 0000000076081000         0000000076A01E58 0000000076A01E70
00007F6035EBCC30  102797        1      1         1         1 row cache       0000000076A01E40         24 perm             0 0000000076081000         0000000076A01E40 0000000076A01E58
00007F6035EBCBC8  102798        1      1         1         1 row cache       0000000076A01E28         24 perm             0 0000000076081000         0000000076A01E28 0000000076A01E40
00007F6035EBCB60  102799        1      1         1         1 row cache       0000000076A01E10         24 perm             0 0000000076081000         0000000076A01E10 0000000076A01E28
00007F6035EBCAF8  102800        1      1         1         1 row cache       0000000076A01D80        144 perm             0 0000000076081000         0000000076A01D80 0000000076A01E10
00007F6035EBCA90  102801        1      1         1         1 row cache mutex 0000000076A01570       2064 perm             0 0000000076081000     512 0000000076A01570 0000000076A01D80
00007F6035EBCA28  102802        1      1         1         1 row cache mutex 00000000769FE560      12304 perm             0 0000000076081000     512 00000000769FE560 0000000076A01570
00007F6035EBC9C0  102803        1      1         1         1 row cache hash  00000000769FC550       8208 perm             0 0000000076081000     512 00000000769FC550 00000000769FE560
00007F6035EBC958  102804        1      1         1         1 row cache       00000000769FC538         24 perm             0 0000000076081000         00000000769FC538 00000000769FC550
00007F6035EBC8F0  102805        1      1         1         1 row cache       00000000769FC520         24 perm             0 0000000076081000         00000000769FC520 00000000769FC538
00007F6035EBC888  102806        1      1         1         1 row cache       00000000769FC508         24 perm             0 0000000076081000         00000000769FC508 00000000769FC520
00007F6035EBC820  102807        1      1         1         1 row cache       00000000769FC4F0         24 perm             0 0000000076081000         00000000769FC4F0 00000000769FC508
00007F6035EBC7B8  102808        1      1         1         1 row cache       00000000769FC4D8         24 perm             0 0000000076081000         00000000769FC4D8 00000000769FC4F0
00007F6035EBC750  102809        1      1         1         1 row cache       00000000769FC448        144 perm             0 0000000076081000         00000000769FC448 00000000769FC4D8
00007F6035EBC6E8  102810        1      1         1         1 row cache mutex 00000000769EC438      65552 perm             0 0000000076081000   16384 00000000769EC438 00000000769FC448
00007F6035EBC680  102811        1      1         1         1 row cache mutex 000000007698C428     393232 perm             0 0000000076081000   16384 000000007698C428 00000000769EC438
00007F6035EBC618  102812        1      1         1         1 row cache hash  000000007694C418     262160 perm             0 0000000076081000   16384 000000007694C418 000000007698C428
00007F6035EBC5B0  102813        1      1         1         1 row cache       000000007694C400         24 perm             0 0000000076081000         000000007694C400 000000007694C418
00007F6035EBC548  102814        1      1         1         1 row cache       000000007694C3E8         24 perm             0 0000000076081000         000000007694C3E8 000000007694C400
00007F6035EBC4E0  102815        1      1         1         1 row cache       000000007694C3D0         24 perm             0 0000000076081000         000000007694C3D0 000000007694C3E8
00007F6035EBC478  102816        1      1         1         1 row cache       000000007694C3B8         24 perm             0 0000000076081000         000000007694C3B8 000000007694C3D0
00007F6035EBC410  102817        1      1         1         1 row cache       000000007694C3A0         24 perm             0 0000000076081000         000000007694C3A0 000000007694C3B8
00007F6035EBC3A8  102818        1      1         1         1 row cache       000000007694C310        144 perm             0 0000000076081000         000000007694C310 000000007694C3A0
00007F6035EBC340  102819        1      1         1         1 row cache mutex 000000007693C300      65552 perm             0 0000000076081000   16384 000000007693C300 000000007694C310
00007F6035EBC2D8  102820        1      1         1         1 row cache mutex 00000000768DC2F0     393232 perm             0 0000000076081000   16384 00000000768DC2F0 000000007693C300
00007F6035EBC270  102821        1      1         1         1 row cache hash  000000007689C2E0     262160 perm             0 0000000076081000   16384 000000007689C2E0 00000000768DC2F0
00007F6035EBC208  102822        1      1         1         1 row cache       000000007689C2C8         24 perm             0 0000000076081000         000000007689C2C8 000000007689C2E0
00007F6035EBC1A0  102823        1      1         1         1 row cache       000000007689C2B0         24 perm             0 0000000076081000         000000007689C2B0 000000007689C2C8
00007F6035EBC138  102824        1      1         1         1 row cache       000000007689C298         24 perm             0 0000000076081000         000000007689C298 000000007689C2B0
00007F6035EBC0D0  102825        1      1         1         1 row cache       000000007689C280         24 perm             0 0000000076081000         000000007689C280 000000007689C298
00007F6035EBC068  102826        1      1         1         1 row cache       000000007689C268         24 perm             0 0000000076081000         000000007689C268 000000007689C280
00007F6035EBC000  102827        1      1         1         1 row cache       000000007689C1D8        144 perm             0 0000000076081000         000000007689C1D8 000000007689C268
00007F6035EBBF98  102828        1      1         1         1 row cache mutex 000000007688C1C8      65552 perm             0 0000000076081000   16384 000000007688C1C8 000000007689C1D8
00007F6035EBBF30  102829        1      1         1         1 row cache mutex 000000007682C1B8     393232 perm             0 0000000076081000   16384 000000007682C1B8 000000007688C1C8
00007F6035EBBEC8  102830        1      1         1         1 row cache hash  00000000767EC1A8     262160 perm             0 0000000076081000   16384 00000000767EC1A8 000000007682C1B8
00007F6035EBBE60  102831        1      1         1         1 row cache       00000000767EC190         24 perm             0 0000000076081000         00000000767EC190 00000000767EC1A8
00007F6035EBBDF8  102832        1      1         1         1 row cache       00000000767EC178         24 perm             0 0000000076081000         00000000767EC178 00000000767EC190
00007F6035EBBD90  102833        1      1         1         1 row cache       00000000767EC160         24 perm             0 0000000076081000         00000000767EC160 00000000767EC178
00007F6035EBBD28  102834        1      1         1         1 row cache       00000000767EC148         24 perm             0 0000000076081000         00000000767EC148 00000000767EC160
00007F6035EBBCC0  102835        1      1         1         1 row cache       00000000767EC130         24 perm             0 0000000076081000         00000000767EC130 00000000767EC148
00007F6035EBBC58  102836        1      1         1         1 row cache       00000000767EC0A0        144 perm             0 0000000076081000         00000000767EC0A0 00000000767EC130
00007F6035EBBBF0  102837        1      1         1         1 row cache mutex 00000000767CC090     131088 perm             0 0000000076081000   32768 00000000767CC090 00000000767EC0A0
00007F6035EBBB88  102838        1      1         1         1 row cache mutex 000000007670C080     786448 perm             0 0000000076081000   32768 000000007670C080 00000000767CC090
00007F6035EBBB20  102839        1      1         1         1 row cache hash  000000007668C070     524304 perm             0 0000000076081000   32768 000000007668C070 000000007670C080
00007F6035EBBAB8  102840        1      1         1         1 row cache       000000007668C058         24 perm             0 0000000076081000         000000007668C058 000000007668C070
00007F6035EBBA50  102841        1      1         1         1 row cache       000000007668C040         24 perm             0 0000000076081000         000000007668C040 000000007668C058
00007F6035EBB9E8  102842        1      1         1         1 row cache       000000007668C028         24 perm             0 0000000076081000         000000007668C028 000000007668C040
00007F6035EBB980  102843        1      1         1         1 row cache       000000007668C010         24 perm             0 0000000076081000         000000007668C010 000000007668C028
00007F6035EBB918  102844        1      1         1         1 row cache       000000007668BFF8         24 perm             0 0000000076081000         000000007668BFF8 000000007668C010
00007F6035EBB8B0  102845        1      1         1         1 row cache       000000007668BF68        144 perm             0 0000000076081000         000000007668BF68 000000007668BFF8
00007F6035EBB848  102846        1      1         1         1 row cache mutex 000000007666BF58     131088 perm             0 0000000076081000   32768 000000007666BF58 000000007668BF68
00007F6035EBB7E0  102847        1      1         1         1 row cache mutex 00000000765ABF48     786448 perm             0 0000000076081000   32768 00000000765ABF48 000000007666BF58
00007F6035EBB778  102848        1      1         1         1 row cache hash  000000007652BF38     524304 perm             0 0000000076081000   32768 000000007652BF38 00000000765ABF48
00007F6035EBB710  102849        1      1         1         1 row cache       000000007652BF20         24 perm             0 0000000076081000         000000007652BF20 000000007652BF38
00007F6035EBB6A8  102850        1      1         1         1 row cache       000000007652BF08         24 perm             0 0000000076081000         000000007652BF08 000000007652BF20
00007F6035EBB640  102851        1      1         1         1 row cache       000000007652BEF0         24 perm             0 0000000076081000         000000007652BEF0 000000007652BF08
00007F6035EBB5D8  102852        1      1         1         1 row cache       000000007652BED8         24 perm             0 0000000076081000         000000007652BED8 000000007652BEF0
00007F6035EBB570  102853        1      1         1         1 row cache       000000007652BEC0         24 perm             0 0000000076081000         000000007652BEC0 000000007652BED8
00007F6035EBB508  102854        1      1         1         1 row cache       000000007652BE30        144 perm             0 0000000076081000         000000007652BE30 000000007652BEC0
00007F6035EBB4A0  102855        1      1         1         1 row cache mutex 000000007650BE20     131088 perm             0 0000000076081000   32768 000000007650BE20 000000007652BE30
00007F6035EBB438  102856        1      1         1         1 row cache mutex 000000007644BE10     786448 perm             0 0000000076081000   32768 000000007644BE10 000000007650BE20
00007F6035EBB3D0  102857        1      1         1         1 row cache hash  00000000763CBE00     524304 perm             0 0000000076081000   32768 00000000763CBE00 000000007644BE10
00007F6035EBB368  102858        1      1         1         1 row cache       00000000763CBDE8         24 perm             0 0000000076081000         00000000763CBDE8 00000000763CBE00
00007F6035EBB300  102859        1      1         1         1 row cache       00000000763CBDD0         24 perm             0 0000000076081000         00000000763CBDD0 00000000763CBDE8
00007F6035EBB298  102860        1      1         1         1 row cache       00000000763CBDB8         24 perm             0 0000000076081000         00000000763CBDB8 00000000763CBDD0
00007F6035EBB230  102861        1      1         1         1 row cache       00000000763CBDA0         24 perm             0 0000000076081000         00000000763CBDA0 00000000763CBDB8
00007F6035EBB1C8  102862        1      1         1         1 row cache       00000000763CBD88         24 perm             0 0000000076081000         00000000763CBD88 00000000763CBDA0
00007F6035EBB160  102863        1      1         1         1 row cache       00000000763CBCF8        144 perm             0 0000000076081000         00000000763CBCF8 00000000763CBD88
00007F6035EBB0F8  102864        1      1         1         1 row cache mutex 00000000763ABCE8     131088 perm             0 0000000076081000   32768 00000000763ABCE8 00000000763CBCF8
00007F6035EBB090  102865        1      1         1         1 row cache mutex 00000000762EBCD8     786448 perm             0 0000000076081000   32768 00000000762EBCD8 00000000763ABCE8
00007F6035EBB028  102866        1      1         1         1 row cache hash  000000007626BCC8     524304 perm             0 0000000076081000   32768 000000007626BCC8 00000000762EBCD8
00007F6035EBAFC0  102867        1      1         1         1 row cache       000000007626BCB0         24 perm             0 0000000076081000         000000007626BCB0 000000007626BCC8
00007F6035EBAF58  102868        1      1         1         1 row cache       000000007626BC98         24 perm             0 0000000076081000         000000007626BC98 000000007626BCB0
00007F6035EBAEF0  102869        1      1         1         1 row cache       000000007626BC80         24 perm             0 0000000076081000         000000007626BC80 000000007626BC98
00007F6035EBAE88  102870        1      1         1         1 row cache       000000007626BC68         24 perm             0 0000000076081000         000000007626BC68 000000007626BC80
00007F6035EBAE20  102871        1      1         1         1 row cache       000000007626BC50         24 perm             0 0000000076081000         000000007626BC50 000000007626BC68
00007F6035EBADB8  102872        1      1         1         1 row cache       000000007626BBC0        144 perm             0 0000000076081000         000000007626BBC0 000000007626BC50
00007F6035EBAD50  102873        1      1         1         1 row cache mutex 000000007626B3B0       2064 perm             0 0000000076081000     512 000000007626B3B0 000000007626BBC0
00007F6035EBACE8  102874        1      1         1         1 row cache mutex 00000000762683A0      12304 perm             0 0000000076081000     512 00000000762683A0 000000007626B3B0
00007F6035EBAC80  102875        1      1         1         1 row cache hash  0000000076266390       8208 perm             0 0000000076081000     512 0000000076266390 00000000762683A0
00007F6035EBAC18  102876        1      1         1         1 row cache       0000000076266378         24 perm             0 0000000076081000         0000000076266378 0000000076266390
00007F6035EBABB0  102877        1      1         1         1 row cache       0000000076266360         24 perm             0 0000000076081000         0000000076266360 0000000076266378
00007F6035EBAB48  102878        1      1         1         1 row cache       0000000076266348         24 perm             0 0000000076081000         0000000076266348 0000000076266360
00007F6035EBAAE0  102879        1      1         1         1 row cache       0000000076266330         24 perm             0 0000000076081000         0000000076266330 0000000076266348
00007F6035EBAA78  102880        1      1         1         1 row cache       0000000076266318         24 perm             0 0000000076081000         0000000076266318 0000000076266330
00007F6035EBAA10  102881        1      1         1         1 row cache       0000000076266288        144 perm             0 0000000076081000         0000000076266288 0000000076266318
00007F6035EBA9A8  102882        1      1         1         1 row cache mutex 0000000076265E78       1040 perm             0 0000000076081000     256 0000000076265E78 0000000076266288
00007F6035EBA940  102883        1      1         1         1 row cache mutex 0000000076264668       6160 perm             0 0000000076081000     256 0000000076264668 0000000076265E78
00007F6035EBA8D8  102884        1      1         1         1 row cache hash  0000000076263658       4112 perm             0 0000000076081000     256 0000000076263658 0000000076264668
00007F6035EBA870  102885        1      1         1         1 row cache       0000000076263640         24 perm             0 0000000076081000         0000000076263640 0000000076263658
00007F6035EBA808  102886        1      1         1         1 row cache       0000000076263628         24 perm             0 0000000076081000         0000000076263628 0000000076263640
00007F6035EBA7A0  102887        1      1         1         1 row cache       0000000076263610         24 perm             0 0000000076081000         0000000076263610 0000000076263628
00007F6035EBA738  102888        1      1         1         1 row cache       00000000762635F8         24 perm             0 0000000076081000         00000000762635F8 0000000076263610
00007F6035EBA6D0  102889        1      1         1         1 row cache       00000000762635E0         24 perm             0 0000000076081000         00000000762635E0 00000000762635F8
00007F6035EBA668  102890        1      1         1         1 row cache       0000000076263550        144 perm             0 0000000076081000         0000000076263550 00000000762635E0
00007F6035EBA600  102891        1      1         1         1 row cache mutex 0000000076263140       1040 perm             0 0000000076081000     256 0000000076263140 0000000076263550
00007F6035EBA598  102892        1      1         1         1 row cache mutex 0000000076261930       6160 perm             0 0000000076081000     256 0000000076261930 0000000076263140
00007F6035EBA530  102893        1      1         1         1 row cache hash  0000000076260920       4112 perm             0 0000000076081000     256 0000000076260920 0000000076261930
00007F6035EBA4C8  102894        1      1         1         1 row cache       0000000076260908         24 perm             0 0000000076081000         0000000076260908 0000000076260920
00007F6035EBA460  102895        1      1         1         1 row cache       00000000762608F0         24 perm             0 0000000076081000         00000000762608F0 0000000076260908
00007F6035EBA3F8  102896        1      1         1         1 row cache       00000000762608D8         24 perm             0 0000000076081000         00000000762608D8 00000000762608F0
00007F6035EBA390  102897        1      1         1         1 row cache       00000000762608C0         24 perm             0 0000000076081000         00000000762608C0 00000000762608D8
00007F6035EBA328  102898        1      1         1         1 row cache       00000000762608A8         24 perm             0 0000000076081000         00000000762608A8 00000000762608C0
00007F6035EBA2C0  102899        1      1         1         1 row cache       0000000076260818        144 perm             0 0000000076081000         0000000076260818 00000000762608A8
00007F6035EBA258  102900        1      1         1         1 row cache mutex 0000000076260408       1040 perm             0 0000000076081000     256 0000000076260408 0000000076260818
00007F6035EBA1F0  102901        1      1         1         1 row cache mutex 000000007625EBF8       6160 perm             0 0000000076081000     256 000000007625EBF8 0000000076260408
00007F6035EBA188  102902        1      1         1         1 row cache hash  000000007625DBE8       4112 perm             0 0000000076081000     256 000000007625DBE8 000000007625EBF8
00007F6035EBA120  102903        1      1         1         1 row cache       000000007625DBD0         24 perm             0 0000000076081000         000000007625DBD0 000000007625DBE8
00007F6035EBA0B8  102904        1      1         1         1 row cache       000000007625DBB8         24 perm             0 0000000076081000         000000007625DBB8 000000007625DBD0
00007F6035EBA050  102905        1      1         1         1 row cache       000000007625DBA0         24 perm             0 0000000076081000         000000007625DBA0 000000007625DBB8
00007F6035EB9FE8  102906        1      1         1         1 row cache       000000007625DB88         24 perm             0 0000000076081000         000000007625DB88 000000007625DBA0
00007F6035EB9F80  102907        1      1         1         1 row cache       000000007625DB70         24 perm             0 0000000076081000         000000007625DB70 000000007625DB88
00007F6035EB9F18  102908        1      1         1         1 row cache       000000007625DAE0        144 perm             0 0000000076081000         000000007625DAE0 000000007625DB70
00007F6035EB9EB0  102909        1      1         1         1 row cache mutex 000000007625D6D0       1040 perm             0 0000000076081000     256 000000007625D6D0 000000007625DAE0
00007F6035EB9E48  102910        1      1         1         1 row cache mutex 000000007625BEC0       6160 perm             0 0000000076081000     256 000000007625BEC0 000000007625D6D0
00007F6035EB9DE0  102911        1      1         1         1 row cache hash  000000007625AEB0       4112 perm             0 0000000076081000     256 000000007625AEB0 000000007625BEC0
00007F6035EB9D78  102912        1      1         1         1 row cache       000000007625AE98         24 perm             0 0000000076081000         000000007625AE98 000000007625AEB0
00007F6035EB9D10  102913        1      1         1         1 row cache       000000007625AE80         24 perm             0 0000000076081000         000000007625AE80 000000007625AE98
00007F6035EB9CA8  102914        1      1         1         1 row cache       000000007625AE68         24 perm             0 0000000076081000         000000007625AE68 000000007625AE80
00007F6035EB9C40  102915        1      1         1         1 row cache       000000007625AE50         24 perm             0 0000000076081000         000000007625AE50 000000007625AE68
00007F6035EB9BD8  102916        1      1         1         1 row cache       000000007625AE38         24 perm             0 0000000076081000         000000007625AE38 000000007625AE50
00007F6035EB9B70  102917        1      1         1         1 row cache       000000007625ADA8        144 perm             0 0000000076081000         000000007625ADA8 000000007625AE38
00007F6035EB9B08  102918        1      1         1         1 row cache mutex 000000007625A598       2064 perm             0 0000000076081000     512 000000007625A598 000000007625ADA8
00007F6035EB9AA0  102919        1      1         1         1 row cache mutex 0000000076257588      12304 perm             0 0000000076081000     512 0000000076257588 000000007625A598
00007F6035EB9A38  102920        1      1         1         1 row cache hash  0000000076255578       8208 perm             0 0000000076081000     512 0000000076255578 0000000076257588
00007F6035EB99D0  102921        1      1         1         1 row cache       0000000076255560         24 perm             0 0000000076081000         0000000076255560 0000000076255578
00007F6035EB9968  102922        1      1         1         1 row cache       0000000076255548         24 perm             0 0000000076081000         0000000076255548 0000000076255560
00007F6035EB9900  102923        1      1         1         1 row cache       0000000076255530         24 perm             0 0000000076081000         0000000076255530 0000000076255548
00007F6035EB9898  102924        1      1         1         1 row cache       0000000076255518         24 perm             0 0000000076081000         0000000076255518 0000000076255530
00007F6035EB9830  102925        1      1         1         1 row cache       0000000076255500         24 perm             0 0000000076081000         0000000076255500 0000000076255518
00007F6035EB97C8  102926        1      1         1         1 row cache       0000000076255470        144 perm             0 0000000076081000         0000000076255470 0000000076255500
00007F6035EB9760  102927        1      1         1         1 row cache mutex 0000000076255060       1040 perm             0 0000000076081000     256 0000000076255060 0000000076255470
00007F6035EB96F8  102928        1      1         1         1 row cache mutex 0000000076253850       6160 perm             0 0000000076081000     256 0000000076253850 0000000076255060
00007F6035EB9690  102929        1      1         1         1 row cache hash  0000000076252840       4112 perm             0 0000000076081000     256 0000000076252840 0000000076253850
00007F6035EB9628  102930        1      1         1         1 row cache       0000000076252828         24 perm             0 0000000076081000         0000000076252828 0000000076252840
00007F6035EB95C0  102931        1      1         1         1 row cache       0000000076252810         24 perm             0 0000000076081000         0000000076252810 0000000076252828
00007F6035EB9558  102932        1      1         1         1 row cache       00000000762527F8         24 perm             0 0000000076081000         00000000762527F8 0000000076252810
00007F6035EB94F0  102933        1      1         1         1 row cache       00000000762527E0         24 perm             0 0000000076081000         00000000762527E0 00000000762527F8
00007F6035EB9488  102934        1      1         1         1 row cache       00000000762527C8         24 perm             0 0000000076081000         00000000762527C8 00000000762527E0
00007F6035EB9420  102935        1      1         1         1 row cache       0000000076252738        144 perm             0 0000000076081000         0000000076252738 00000000762527C8
00007F6035EB93B8  102936        1      1         1         1 row cache mutex 0000000076252328       1040 perm             0 0000000076081000     256 0000000076252328 0000000076252738
00007F6035EB9350  102937        1      1         1         1 row cache mutex 0000000076250B18       6160 perm             0 0000000076081000     256 0000000076250B18 0000000076252328
00007F6035EB92E8  102938        1      1         1         1 row cache hash  000000007624FB08       4112 perm             0 0000000076081000     256 000000007624FB08 0000000076250B18
00007F6035EB9280  102939        1      1         1         1 row cache       000000007624FAF0         24 perm             0 0000000076081000         000000007624FAF0 000000007624FB08
00007F6035EB9218  102940        1      1         1         1 row cache       000000007624FAD8         24 perm             0 0000000076081000         000000007624FAD8 000000007624FAF0
00007F6035EB91B0  102941        1      1         1         1 row cache       000000007624FAC0         24 perm             0 0000000076081000         000000007624FAC0 000000007624FAD8
00007F6035EB9148  102942        1      1         1         1 row cache       000000007624FAA8         24 perm             0 0000000076081000         000000007624FAA8 000000007624FAC0
00007F6035EB90E0  102943        1      1         1         1 row cache       000000007624FA90         24 perm             0 0000000076081000         000000007624FA90 000000007624FAA8
00007F6035EB9078  102944        1      1         1         1 row cache       000000007624FA00        144 perm             0 0000000076081000         000000007624FA00 000000007624FA90
00007F6035EB9010  102945        1      1         1         1 row cache mutex 000000007624F5F0       1040 perm             0 0000000076081000     256 000000007624F5F0 000000007624FA00
00007F6035EB8FA8  102946        1      1         1         1 row cache mutex 000000007624DDE0       6160 perm             0 0000000076081000     256 000000007624DDE0 000000007624F5F0
00007F6035EB8F40  102947        1      1         1         1 row cache hash  000000007624CDD0       4112 perm             0 0000000076081000     256 000000007624CDD0 000000007624DDE0
00007F6035EB8ED8  102948        1      1         1         1 row cache       000000007624CDB8         24 perm             0 0000000076081000         000000007624CDB8 000000007624CDD0
00007F6035EB8E70  102949        1      1         1         1 row cache       000000007624CDA0         24 perm             0 0000000076081000         000000007624CDA0 000000007624CDB8
00007F6035EB8E08  102950        1      1         1         1 row cache       000000007624CD88         24 perm             0 0000000076081000         000000007624CD88 000000007624CDA0
00007F6035EB8DA0  102951        1      1         1         1 row cache       000000007624CD70         24 perm             0 0000000076081000         000000007624CD70 000000007624CD88
00007F6035EB8D38  102952        1      1         1         1 row cache       000000007624CD58         24 perm             0 0000000076081000         000000007624CD58 000000007624CD70
00007F6035EB8CD0  102953        1      1         1         1 row cache       000000007624CCC8        144 perm             0 0000000076081000         000000007624CCC8 000000007624CD58
00007F6035EB8C68  102954        1      1         1         1 row cache mutex 000000007624C4B8       2064 perm             0 0000000076081000     512 000000007624C4B8 000000007624CCC8
00007F6035EB8C00  102955        1      1         1         1 row cache mutex 00000000762494A8      12304 perm             0 0000000076081000     512 00000000762494A8 000000007624C4B8
00007F6035EB8B98  102956        1      1         1         1 row cache hash  0000000076247498       8208 perm             0 0000000076081000     512 0000000076247498 00000000762494A8
00007F6035EB8B30  102957        1      1         1         1 row cache       0000000076247480         24 perm             0 0000000076081000         0000000076247480 0000000076247498
00007F6035EB8AC8  102958        1      1         1         1 row cache       0000000076247468         24 perm             0 0000000076081000         0000000076247468 0000000076247480
00007F6035EB8A60  102959        1      1         1         1 row cache       0000000076247450         24 perm             0 0000000076081000         0000000076247450 0000000076247468
00007F6035EB89F8  102960        1      1         1         1 row cache       0000000076247438         24 perm             0 0000000076081000         0000000076247438 0000000076247450
00007F6035EB8990  102961        1      1         1         1 row cache       0000000076247420         24 perm             0 0000000076081000         0000000076247420 0000000076247438
00007F6035EB8928  102962        1      1         1         1 row cache       0000000076247390        144 perm             0 0000000076081000         0000000076247390 0000000076247420
00007F6035EB88C0  102963        1      1         1         1 row cache mutex 0000000076246F80       1040 perm             0 0000000076081000     256 0000000076246F80 0000000076247390
00007F6035EB8858  102964        1      1         1         1 row cache mutex 0000000076245770       6160 perm             0 0000000076081000     256 0000000076245770 0000000076246F80
00007F6035EB87F0  102965        1      1         1         1 row cache hash  0000000076244760       4112 perm             0 0000000076081000     256 0000000076244760 0000000076245770
00007F6035EB8788  102966        1      1         1         1 row cache       0000000076244748         24 perm             0 0000000076081000         0000000076244748 0000000076244760
00007F6035EB8720  102967        1      1         1         1 row cache       0000000076244730         24 perm             0 0000000076081000         0000000076244730 0000000076244748
00007F6035EB86B8  102968        1      1         1         1 row cache       0000000076244718         24 perm             0 0000000076081000         0000000076244718 0000000076244730
00007F6035EB8650  102969        1      1         1         1 row cache       0000000076244700         24 perm             0 0000000076081000         0000000076244700 0000000076244718
00007F6035EB85E8  102970        1      1         1         1 row cache       00000000762446E8         24 perm             0 0000000076081000         00000000762446E8 0000000076244700
00007F6035EB8580  102971        1      1         1         1 row cache       0000000076244658        144 perm             0 0000000076081000         0000000076244658 00000000762446E8
00007F6035EB8518  102972        1      1         1         1 row cache mutex 0000000076244248       1040 perm             0 0000000076081000     256 0000000076244248 0000000076244658
00007F6035EB84B0  102973        1      1         1         1 row cache mutex 0000000076242A38       6160 perm             0 0000000076081000     256 0000000076242A38 0000000076244248
00007F6035EB8448  102974        1      1         1         1 row cache hash  0000000076241A28       4112 perm             0 0000000076081000     256 0000000076241A28 0000000076242A38
00007F6035EB83E0  102975        1      1         1         1 row cache       0000000076241A10         24 perm             0 0000000076081000         0000000076241A10 0000000076241A28
00007F6035EB8378  102976        1      1         1         1 row cache       00000000762419F8         24 perm             0 0000000076081000         00000000762419F8 0000000076241A10
00007F6035EB8310  102977        1      1         1         1 row cache       00000000762419E0         24 perm             0 0000000076081000         00000000762419E0 00000000762419F8
00007F6035EB82A8  102978        1      1         1         1 row cache       00000000762419C8         24 perm             0 0000000076081000         00000000762419C8 00000000762419E0
00007F6035EB8240  102979        1      1         1         1 row cache       00000000762419B0         24 perm             0 0000000076081000         00000000762419B0 00000000762419C8
00007F6035EB81D8  102980        1      1         1         1 row cache       0000000076241920        144 perm             0 0000000076081000         0000000076241920 00000000762419B0
00007F6035EB8170  102981        1      1         1         1 row cache mutex 0000000076221910     131088 perm             0 0000000076081000   32768 0000000076221910 0000000076241920
00007F6035EB8108  102982        1      1         1         1 row cache mutex 0000000076161900     786448 perm             0 0000000076081000   32768 0000000076161900 0000000076221910
00007F6035EB80A0  102983        1      1         1         1 row cache hash  00000000760E18F0     524304 perm             0 0000000076081000   32768 00000000760E18F0 0000000076161900
00007F6035EB8038  102984        1      1         1         1 row cache       00000000760E18D8         24 perm             0 0000000076081000         00000000760E18D8 00000000760E18F0
00007F6035EB7FD0  102985        1      1         1         1 row cache       00000000760E18C0         24 perm             0 0000000076081000         00000000760E18C0 00000000760E18D8
00007F6035EB7F68  102986        1      1         1         1 row cache       00000000760E18A8         24 perm             0 0000000076081000         00000000760E18A8 00000000760E18C0
00007F6035EB7F00  102987        1      1         1         1 row cache       00000000760E1890         24 perm             0 0000000076081000         00000000760E1890 00000000760E18A8
00007F6035EB7E98  102988        1      1         1         1 row cache       00000000760E1878         24 perm             0 0000000076081000         00000000760E1878 00000000760E1890
00007F6035EB7E30  102989        1      1         1         1 row cache       00000000760E17E8        144 perm             0 0000000076081000         00000000760E17E8 00000000760E1878
00007F6035EB7DC8  102990        1      1         1         1 row cache mutex 00000000760E13D8       1040 perm             0 0000000076081000     256 00000000760E13D8 00000000760E17E8
00007F6035EB7D60  102991        1      1         1         1 row cache mutex 00000000760DFBC8       6160 perm             0 0000000076081000     256 00000000760DFBC8 00000000760E13D8
00007F6035EB7CF8  102992        1      1         1         1 row cache hash  00000000760DEBB8       4112 perm             0 0000000076081000     256 00000000760DEBB8 00000000760DFBC8
00007F6035EB7C90  102993        1      1         1         1 row cache       00000000760DEBA0         24 perm             0 0000000076081000         00000000760DEBA0 00000000760DEBB8
00007F6035EB7C28  102994        1      1         1         1 row cache       00000000760DEB88         24 perm             0 0000000076081000         00000000760DEB88 00000000760DEBA0
00007F6035EB7BC0  102995        1      1         1         1 row cache       00000000760DEB70         24 perm             0 0000000076081000         00000000760DEB70 00000000760DEB88
00007F6035EB7B58  102996        1      1         1         1 row cache       00000000760DEB58         24 perm             0 0000000076081000         00000000760DEB58 00000000760DEB70
00007F6035EB7AF0  102997        1      1         1         1 row cache       00000000760DEB40         24 perm             0 0000000076081000         00000000760DEB40 00000000760DEB58
00007F6035EB7A88  102998        1      1         1         1 row cache       00000000760DEAB0        144 perm             0 0000000076081000         00000000760DEAB0 00000000760DEB40
00007F6035EB7A20  102999        1      1         1         1 row cache mutex 00000000760DE6A0       1040 perm             0 0000000076081000     256 00000000760DE6A0 00000000760DEAB0
00007F6035EB79B8  103000        1      1         1         1 row cache mutex 00000000760DCE90       6160 perm             0 0000000076081000     256 00000000760DCE90 00000000760DE6A0
00007F6035EB7950  103001        1      1         1         1 row cache hash  00000000760DBE80       4112 perm             0 0000000076081000     256 00000000760DBE80 00000000760DCE90
00007F6035EB78E8  103002        1      1         1         1 row cache       00000000760DBE68         24 perm             0 0000000076081000         00000000760DBE68 00000000760DBE80
00007F6035EB7880  103003        1      1         1         1 row cache       00000000760DBE50         24 perm             0 0000000076081000         00000000760DBE50 00000000760DBE68
00007F6035EB7818  103004        1      1         1         1 row cache       00000000760DBE38         24 perm             0 0000000076081000         00000000760DBE38 00000000760DBE50
00007F6035EB77B0  103005        1      1         1         1 row cache       00000000760DBE20         24 perm             0 0000000076081000         00000000760DBE20 00000000760DBE38
00007F6035EB7748  103006        1      1         1         1 row cache       00000000760DBE08         24 perm             0 0000000076081000         00000000760DBE08 00000000760DBE20
00007F6035EB76E0  103007        1      1         1         1 row cache       00000000760DBD78        144 perm             0 0000000076081000         00000000760DBD78 00000000760DBE08
00007F6035EB7678  103008        1      1         1         1 row cache mutex 00000000760DBD28         80 perm             0 0000000076081000      16 00000000760DBD28 00000000760DBD78
00007F6035EB7610  103009        1      1         1         1 row cache mutex 00000000760DBB98        400 perm             0 0000000076081000      16 00000000760DBB98 00000000760DBD28
00007F6035EB75A8  103010        1      1         1         1 row cache hash  00000000760DBA88        272 perm             0 0000000076081000      16 00000000760DBA88 00000000760DBB98
00007F6035EB7540  103011        1      1         1         1 row cache       00000000760DBA70         24 perm             0 0000000076081000         00000000760DBA70 00000000760DBA88
00007F6035EB74D8  103012        1      1         1         1 row cache       00000000760DBA58         24 perm             0 0000000076081000         00000000760DBA58 00000000760DBA70
00007F6035EB7470  103013        1      1         1         1 row cache       00000000760DBA40         24 perm             0 0000000076081000         00000000760DBA40 00000000760DBA58
00007F6035EB7408  103014        1      1         1         1 row cache       00000000760DBA28         24 perm             0 0000000076081000         00000000760DBA28 00000000760DBA40
00007F6035EB73A0  103015        1      1         1         1 row cache       00000000760DBA10         24 perm             0 0000000076081000         00000000760DBA10 00000000760DBA28
00007F6035EB7338  103016        1      1         1         1 row cache       00000000760DB980        144 perm             0 0000000076081000         00000000760DB980 00000000760DBA10
00007F6035EB72D0  103017        1      1         1         1 row cache mutex 00000000760DB870        272 perm             0 0000000076081000      64 00000000760DB870 00000000760DB980
00007F6035EB7268  103018        1      1         1         1 row cache mutex 00000000760DB260       1552 perm             0 0000000076081000      64 00000000760DB260 00000000760DB870
00007F6035EB7200  103019        1      1         1         1 row cache hash  00000000760DAE50       1040 perm             0 0000000076081000      64 00000000760DAE50 00000000760DB260
00007F6035EB7198  103020        1      1         1         1 row cache       00000000760DAE38         24 perm             0 0000000076081000         00000000760DAE38 00000000760DAE50
00007F6035EB7130  103021        1      1         1         1 row cache       00000000760DAE20         24 perm             0 0000000076081000         00000000760DAE20 00000000760DAE38
00007F6035EB70C8  103022        1      1         1         1 row cache       00000000760DAE08         24 perm             0 0000000076081000         00000000760DAE08 00000000760DAE20
00007F6035EB7060  103023        1      1         1         1 row cache       00000000760DADF0         24 perm             0 0000000076081000         00000000760DADF0 00000000760DAE08
00007F6035EB6FF8  103024        1      1         1         1 row cache       00000000760DADD8         24 perm             0 0000000076081000         00000000760DADD8 00000000760DADF0
00007F6035EB6F90  103025        1      1         1         1 row cache       00000000760DAD48        144 perm             0 0000000076081000         00000000760DAD48 00000000760DADD8
00007F6035EB6F28  103026        1      1         1         1 row cache mutex 00000000760DAC38        272 perm             0 0000000076081000      64 00000000760DAC38 00000000760DAD48
00007F6035EB6EC0  103027        1      1         1         1 row cache mutex 00000000760DA628       1552 perm             0 0000000076081000      64 00000000760DA628 00000000760DAC38
00007F6035EB6E58  103028        1      1         1         1 row cache hash  00000000760DA218       1040 perm             0 0000000076081000      64 00000000760DA218 00000000760DA628
00007F6035EB6DF0  103029        1      1         1         1 row cache       00000000760DA200         24 perm             0 0000000076081000         00000000760DA200 00000000760DA218
00007F6035EB6D88  103030        1      1         1         1 row cache       00000000760DA1E8         24 perm             0 0000000076081000         00000000760DA1E8 00000000760DA200
00007F6035EB6D20  103031        1      1         1         1 row cache       00000000760DA1D0         24 perm             0 0000000076081000         00000000760DA1D0 00000000760DA1E8
00007F6035EB6CB8  103032        1      1         1         1 row cache       00000000760DA1B8         24 perm             0 0000000076081000         00000000760DA1B8 00000000760DA1D0
00007F6035EB6C50  103033        1      1         1         1 row cache       00000000760DA1A0         24 perm             0 0000000076081000         00000000760DA1A0 00000000760DA1B8
00007F6035EB6BE8  103034        1      1         1         1 row cache       00000000760DA110        144 perm             0 0000000076081000         00000000760DA110 00000000760DA1A0
00007F6035EB6B80  103035        1      1         1         1 row cache mutex 00000000760D9900       2064 perm             0 0000000076081000     512 00000000760D9900 00000000760DA110
00007F6035EB6B18  103036        1      1         1         1 row cache mutex 00000000760D68F0      12304 perm             0 0000000076081000     512 00000000760D68F0 00000000760D9900
00007F6035EB6AB0  103037        1      1         1         1 row cache hash  00000000760D48E0       8208 perm             0 0000000076081000     512 00000000760D48E0 00000000760D68F0
00007F6035EB6A48  103038        1      1         1         1 row cache       00000000760D48C8         24 perm             0 0000000076081000         00000000760D48C8 00000000760D48E0
00007F6035EB69E0  103039        1      1         1         1 row cache       00000000760D48B0         24 perm             0 0000000076081000         00000000760D48B0 00000000760D48C8
00007F6035EB6978  103040        1      1         1         1 row cache       00000000760D4898         24 perm             0 0000000076081000         00000000760D4898 00000000760D48B0
00007F6035EB6910  103041        1      1         1         1 row cache       00000000760D4880         24 perm             0 0000000076081000         00000000760D4880 00000000760D4898
00007F6035EB68A8  103042        1      1         1         1 row cache       00000000760D4868         24 perm             0 0000000076081000         00000000760D4868 00000000760D4880
00007F6035EB6840  103043        1      1         1         1 row cache       00000000760D47D8        144 perm             0 0000000076081000         00000000760D47D8 00000000760D4868
00007F6035EB67D8  103044        1      1         1         1 row cache mutex 00000000760D3FC8       2064 perm             0 0000000076081000     512 00000000760D3FC8 00000000760D47D8
00007F6035EB6770  103045        1      1         1         1 row cache mutex 00000000760D0FB8      12304 perm             0 0000000076081000     512 00000000760D0FB8 00000000760D3FC8
00007F6035EB6708  103046        1      1         1         1 row cache hash  00000000760CEFA8       8208 perm             0 0000000076081000     512 00000000760CEFA8 00000000760D0FB8
00007F6035EB66A0  103047        1      1         1         1 row cache       00000000760CEF90         24 perm             0 0000000076081000         00000000760CEF90 00000000760CEFA8
00007F6035EB6638  103048        1      1         1         1 row cache       00000000760CEF78         24 perm             0 0000000076081000         00000000760CEF78 00000000760CEF90
00007F6035EB65D0  103049        1      1         1         1 row cache       00000000760CEF60         24 perm             0 0000000076081000         00000000760CEF60 00000000760CEF78
00007F6035EB6568  103050        1      1         1         1 row cache       00000000760CEF48         24 perm             0 0000000076081000         00000000760CEF48 00000000760CEF60
00007F6035EB6500  103051        1      1         1         1 row cache       00000000760CEF30         24 perm             0 0000000076081000         00000000760CEF30 00000000760CEF48
00007F6035EB6498  103052        1      1         1         1 row cache       00000000760CEEA0        144 perm             0 0000000076081000         00000000760CEEA0 00000000760CEF30
00007F6035EB6430  103053        1      1         1         1 row cache mutex 00000000760CDE90       4112 perm             0 0000000076081000    1024 00000000760CDE90 00000000760CEEA0
00007F6035EB63C8  103054        1      1         1         1 row cache mutex 00000000760C7E80      24592 perm             0 0000000076081000    1024 00000000760C7E80 00000000760CDE90
00007F6035EB6360  103055        1      1         1         1 row cache hash  00000000760C3E70      16400 perm             0 0000000076081000    1024 00000000760C3E70 00000000760C7E80
00007F6035EB62F8  103056        1      1         1         1 row cache       00000000760C3E58         24 perm             0 0000000076081000         00000000760C3E58 00000000760C3E70
00007F6035EB6290  103057        1      1         1         1 row cache       00000000760C3E40         24 perm             0 0000000076081000         00000000760C3E40 00000000760C3E58
00007F6035EB6228  103058        1      1         1         1 row cache       00000000760C3E28         24 perm             0 0000000076081000         00000000760C3E28 00000000760C3E40
00007F6035EB61C0  103059        1      1         1         1 row cache       00000000760C3E10         24 perm             0 0000000076081000         00000000760C3E10 00000000760C3E28
00007F6035EB6158  103060        1      1         1         1 row cache       00000000760C3DF8         24 perm             0 0000000076081000         00000000760C3DF8 00000000760C3E10
00007F6035EB60F0  103061        1      1         1         1 row cache       00000000760C3D68        144 perm             0 0000000076081000         00000000760C3D68 00000000760C3DF8
00007F6035EB6088  103062        1      1         1         1 row cache mutex 00000000760C3958       1040 perm             0 0000000076081000     256 00000000760C3958 00000000760C3D68
00007F6035EB6020  103063        1      1         1         1 row cache mutex 00000000760C2148       6160 perm             0 0000000076081000     256 00000000760C2148 00000000760C3958
00007F6035EB5FB8  103064        1      1         1         1 row cache hash  00000000760C1138       4112 perm             0 0000000076081000     256 00000000760C1138 00000000760C2148
00007F6035EB5F50  103065        1      1         1         1 row cache       00000000760C1120         24 perm             0 0000000076081000         00000000760C1120 00000000760C1138
00007F6035EB5EE8  103066        1      1         1         1 row cache       00000000760C1108         24 perm             0 0000000076081000         00000000760C1108 00000000760C1120
00007F6035EB5E80  103067        1      1         1         1 row cache       00000000760C10F0         24 perm             0 0000000076081000         00000000760C10F0 00000000760C1108
00007F6035EB5E18  103068        1      1         1         1 row cache       00000000760C10D8         24 perm             0 0000000076081000         00000000760C10D8 00000000760C10F0
00007F6035EB5DB0  103069        1      1         1         1 row cache       00000000760C10C0         24 perm             0 0000000076081000         00000000760C10C0 00000000760C10D8
00007F6035EB5D48  103070        1      1         1         1 row cache       00000000760C1030        144 perm             0 0000000076081000         00000000760C1030 00000000760C10C0
00007F6035EB5CE0  103071        1      1         1         1 row cache mutex 0000000076081020     262160 perm             0 0000000076081000   65536 0000000076081020 00000000760C1030
564 rows selected.
--//可以发现许多情况中间出现5个24大小的chunk,也有小部分中间出现32大小的chunk。大部分都是5个。
--//后记:直接执行如下:
SELECT a.*
      ,CASE
          WHEN ksmchcom = 'row cache mutex' AND MOD (KSMCHSIZ - 16, 24) = 0 THEN (KSMCHSIZ - 16) / 24
          WHEN ksmchcom = 'row cache mutex' AND MOD (KSMCHSIZ - 16, 24) <> 0 THEN (KSMCHSIZ - 16) / 4
          WHEN ksmchcom = 'row cache hash' AND MOD (KSMCHSIZ - 16, 16) = 0 THEN (KSMCHSIZ - 16) / 16
       END
          buckets
      ,a.KSMCHPTR KSMCHPTR_BEGIN
      ,TO_CHAR (TO_NUMBER (a.KSMCHPTR, 'XXXXXXXXXXXXXXXX') + a.KSMCHSIZ, 'FM0XXXXXXXXXXXXXXX') "KSMCHPTR_END+1"
  FROM x$ksmsp a
   WHERE KSMCHCOM LIKE 'row cache%';
--//从下往上看,chunk都是连接在一起的.
--//补充可以执行如下验证:
$ cat row_cache2.sql
/* Formatted on 2026-08-14 17:02:56 (QP5 v5.277) */
WITH x1
        AS (  SELECT a.*
                    ,CASE
                        WHEN ksmchcom = 'row cache mutex' AND MOD (KSMCHSIZ - 16, 24) = 0 THEN (KSMCHSIZ - 16) / 24
                        WHEN ksmchcom = 'row cache mutex' AND MOD (KSMCHSIZ - 16, 24) <> 0 THEN (KSMCHSIZ - 16) / 4
                        WHEN ksmchcom = 'row cache hash' AND MOD (KSMCHSIZ - 16, 16) = 0 THEN (KSMCHSIZ - 16) / 16
                     END
                        buckets
                    ,a.KSMCHPTR KSMCHPTR_BEGIN
                    ,TO_CHAR (TO_NUMBER (a.KSMCHPTR, 'XXXXXXXXXXXXXXXX') + a.KSMCHSIZ, 'FM0XXXXXXXXXXXXXXX')
                        "KSMCHPTR_END+1"
                FROM x$ksmsp a
               WHERE    KSMCHCOM LIKE 'row cache%'
                    -- OR (KSMCHCOM = 'row cache' AND (KSMCHSIZ = 144 OR ksmchsiz = 24 OR ksmchsiz = 32 or ksmchsiz=64))
            ORDER BY 15)
    ,x2
        AS (SELECT x1.*
                  ,"KSMCHPTR_END+1" KSMCHPTR_END
                  ,LEAD (KSMCHPTR_BEGIN, 1) OVER (ORDER BY KSMCHPTR_BEGIN) KSMCHPTR_next
              FROM x1)
SELECT *
  FROM x2
 WHERE KSMCHPTR_END <> KSMCHPTR_next;

SYS@book> @ row_cache2
ADDR               INDX  INST_ID CON_ID  KSMCHIDX  KSMCHDUR KSMCHCOM                         KSMCHPTR           KSMCHSIZ KSMCHCLS  KSMCHTYP KSMCHPAR         BUCKETS KSMCHPTR_BEGIN   KSMCHPTR_END+1    KSMCHPTR_END      KSMCHPTR_NEXT
---------------- ------ -------- ------ --------- --------- -------------------------------- ---------------- ---------- -------- --------- ---------------- ------- ---------------- ----------------- ----------------- ----------------
00007F58360FF660  98876        1      1         1         1 row cache                        0000000076A46BA8         24 perm             0 0000000076081000         0000000076A46BA8 0000000076A46BC0  0000000076A46BC0  00000000774C8628
--//出现地址跳跃的地方是两者的KSMCHPAR不同,KSMCHPAR=0000000077004000,0000000076081000

SYS@book> select * from x$ksmsp where KSMCHSIZ=144 and KSMCHCOM='row cache';
ADDR                INDX  INST_ID CON_ID  KSMCHIDX  KSMCHDUR KSMCHCOM   KSMCHPTR           KSMCHSIZ KSMCHCLS  KSMCHTYP KSMCHPAR
---------------- ------- -------- ------ --------- --------- ---------- ---------------- ---------- -------- --------- ----------------
00007F6035F2F6D8  101085        1      1         1         1 row cache  00000000779D7B60        144 perm             0 0000000077004000
00007F6035F2F330  101094        1      1         1         1 row cache  00000000779D6428        144 perm             0 0000000077004000
00007F6035F2EF88  101103        1      1         1         1 row cache  00000000779AA2F0        144 perm             0 0000000077004000
00007F6035F2EBE0  101112        1      1         1         1 row cache  00000000779A49B8        144 perm             0 0000000077004000
00007F6035F2E838  101121        1      1         1         1 row cache  0000000077844880        144 perm             0 0000000077004000
00007F6035F2E490  101130        1      1         1         1 row cache  00000000776E4740        144 perm             0 0000000077004000
00007F6035F2E0E8  101139        1      1         1         1 row cache  00000000776E3B08        144 perm             0 0000000077004000
00007F6035F2DD40  101148        1      1         1         1 row cache  00000000776E0DD0        144 perm             0 0000000077004000
00007F6035F2D998  101157        1      1         1         1 row cache  00000000776E0718        144 perm             0 0000000077004000
00007F6035F2D5F0  101166        1      1         1         1 row cache  00000000775805E0        144 perm             0 0000000077004000
00007F6035F2D248  101175        1      1         1         1 row cache  000000007757D8A8        144 perm             0 0000000077004000
00007F6035F2CEA0  101184        1      1         1         1 row cache  000000007757AB70        144 perm             0 0000000077004000
00007F6035F2CAF8  101193        1      1         1         1 row cache  00000000774CAA38        144 perm             0 0000000077004000
00007F6035F089F8  102611        1      1         1         1 row cache  0000000076A45EA0        144 perm             0 0000000076081000
00007F6035F08650  102620        1      1         1         1 row cache  0000000076A45268        144 perm             0 0000000076081000
00007F6035F082A8  102629        1      1         1         1 row cache  0000000076A44630        144 perm             0 0000000076081000
00007F6035F07F00  102638        1      1         1         1 row cache  0000000076A439F8        144 perm             0 0000000076081000
00007F6035F07B58  102647        1      1         1         1 row cache  0000000076A40CC0        144 perm             0 0000000076081000
00007F6035F077B0  102656        1      1         1         1 row cache  0000000076A3DF88        144 perm             0 0000000076081000
00007F6035F07408  102665        1      1         1         1 row cache  0000000076A38650        144 perm             0 0000000076081000
00007F6035F07060  102674        1      1         1         1 row cache  0000000076A384E8        144 perm             0 0000000076081000
00007F6035F06CB8  102683        1      1         1         1 row cache  0000000076A357B0        144 perm             0 0000000076081000
00007F6035F06910  102692        1      1         1         1 row cache  0000000076A2FE78        144 perm             0 0000000076081000
00007F6035F06568  102701        1      1         1         1 row cache  0000000076A2E740        144 perm             0 0000000076081000
00007F6035F061C0  102710        1      1         1         1 row cache  0000000076A28E08        144 perm             0 0000000076081000
00007F6035F05E18  102719        1      1         1         1 row cache  0000000076A234D0        144 perm             0 0000000076081000
00007F6035F05A70  102728        1      1         1         1 row cache  0000000076A1DB98        144 perm             0 0000000076081000
00007F6035F056C8  102737        1      1         1         1 row cache  0000000076A18260        144 perm             0 0000000076081000
00007F6035F05320  102746        1      1         1         1 row cache  0000000076A12928        144 perm             0 0000000076081000
00007F6035F04F78  102755        1      1         1         1 row cache  0000000076A0CFF0        144 perm             0 0000000076081000
00007F6035F04BD0  102764        1      1         1         1 row cache  0000000076A076B8        144 perm             0 0000000076081000
00007F6035F04828  102773        1      1         1         1 row cache  0000000076A01D80        144 perm             0 0000000076081000
00007F6035F04480  102782        1      1         1         1 row cache  00000000769FC448        144 perm             0 0000000076081000
00007F6035F040D8  102791        1      1         1         1 row cache  000000007694C310        144 perm             0 0000000076081000
00007F6035F03D30  102800        1      1         1         1 row cache  000000007689C1D8        144 perm             0 0000000076081000
00007F6035F03988  102809        1      1         1         1 row cache  00000000767EC0A0        144 perm             0 0000000076081000
00007F6035F035E0  102818        1      1         1         1 row cache  000000007668BF68        144 perm             0 0000000076081000
00007F6035F03238  102827        1      1         1         1 row cache  000000007652BE30        144 perm             0 0000000076081000
00007F6035F02E90  102836        1      1         1         1 row cache  00000000763CBCF8        144 perm             0 0000000076081000
00007F6035F02AE8  102845        1      1         1         1 row cache  000000007626BBC0        144 perm             0 0000000076081000
00007F6035F02740  102854        1      1         1         1 row cache  0000000076266288        144 perm             0 0000000076081000
00007F6035F02398  102863        1      1         1         1 row cache  0000000076263550        144 perm             0 0000000076081000
00007F6035F01FF0  102872        1      1         1         1 row cache  0000000076260818        144 perm             0 0000000076081000
00007F6035F01C48  102881        1      1         1         1 row cache  000000007625DAE0        144 perm             0 0000000076081000
00007F6035F018A0  102890        1      1         1         1 row cache  000000007625ADA8        144 perm             0 0000000076081000
00007F6035F014F8  102899        1      1         1         1 row cache  0000000076255470        144 perm             0 0000000076081000
00007F6035F01150  102908        1      1         1         1 row cache  0000000076252738        144 perm             0 0000000076081000
00007F6035F00DA8  102917        1      1         1         1 row cache  000000007624FA00        144 perm             0 0000000076081000
00007F6035F00A00  102926        1      1         1         1 row cache  000000007624CCC8        144 perm             0 0000000076081000
00007F6035F00658  102935        1      1         1         1 row cache  0000000076247390        144 perm             0 0000000076081000
00007F6035F002B0  102944        1      1         1         1 row cache  0000000076244658        144 perm             0 0000000076081000
00007F6035EFFE18  102953        1      1         1         1 row cache  0000000076241920        144 perm             0 0000000076081000
00007F6035EFFA70  102962        1      1         1         1 row cache  00000000760E17E8        144 perm             0 0000000076081000
00007F6035EFF6C8  102971        1      1         1         1 row cache  00000000760DEAB0        144 perm             0 0000000076081000
00007F6035EFF320  102980        1      1         1         1 row cache  00000000760DBD78        144 perm             0 0000000076081000
00007F6035EFEF78  102989        1      1         1         1 row cache  00000000760DB980        144 perm             0 0000000076081000
00007F6035EFEBD0  102998        1      1         1         1 row cache  00000000760DAD48        144 perm             0 0000000076081000
00007F6035EFE828  103007        1      1         1         1 row cache  00000000760DA110        144 perm             0 0000000076081000
00007F6035EFE480  103016        1      1         1         1 row cache  00000000760D47D8        144 perm             0 0000000076081000
00007F6035EFE0D8  103025        1      1         1         1 row cache  00000000760CEEA0        144 perm             0 0000000076081000
00007F6035EFDD30  103034        1      1         1         1 row cache  00000000760C3D68        144 perm             0 0000000076081000
00007F6035EFD988  103043        1      1         1         1 row cache  00000000760C1030        144 perm             0 0000000076081000
62 rows selected.
--//前面取2条记录,结尾取2条记录,KSMCHPT+0x16. 用于查询

$ od -t x8  -A x -w64  61000000 | egrep -i "00000000760C1040|00000000760C3D78|00000000779D7B70|00000000779D6438"
164c86c0 0000000076a2e750 00000000776e4750 0000000077844890 00000000779aa300 00000000779d6438 00000000760db990 00000000760da120 00000000779d7b70
164c8740 0000000076a38660 0000000076a28e18 0000000076a0d000 0000000076a12938 0000000076a18270 0000000076a1dba8 0000000076a234e0 00000000760c3d78
164c8800 00000000760e17f8 0000000076a2fe88 00000000779aa300 0000000076a01d90 0000000076a076c8 00000000760c1040 0000000076244668 0000000076a43a08

--//文件偏移量+ 加上0x0000000061000000。
SYS@book> @ fchaz 774c86c0
LOC  KSMCHPTR          KSMCHIDX  KSMCHDUR KSMCHCOM                           KSMCHSIZ KSMCHCLS  KSMCHTYP KSMCHPAR         KSMCHPTR_BEGIN   KSMCHPTR_END+1
---- ---------------- --------- --------- -------------------------------- ---------- -------- --------- ---------------- ---------------- -----------------
VSGA 00000000774C8668         1         1 row cache                               544 perm             0 0000000077004000 00000000774C8668 00000000774C8888

SYS@book> @ fchaz 774c8800
LOC  KSMCHPTR          KSMCHIDX  KSMCHDUR KSMCHCOM                           KSMCHSIZ KSMCHCLS  KSMCHTYP KSMCHPAR         KSMCHPTR_BEGIN   KSMCHPTR_END+1
---- ---------------- --------- --------- -------------------------------- ---------- -------- --------- ---------------- ---------------- -----------------
VSGA 00000000774C8668         1         1 row cache                               544 perm             0 0000000077004000 00000000774C8668 00000000774C8888
--//在同一个chunk里面,说明以上chunk大小等于144的地址保存在该chunk里面,大小等于544.
--// (544-16)/8  = 66, 一共66个地址。

SYS@book> @ opeek 00000000774C8668 544 1
New tracefile_identifier = /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_3877_0001.trc
[0774C8668, 0774C8888) = 00000221 00B38F00 16B4E6AA 00000000 776E0728 00000000 7757AB80 00000000 775805F0 00000000 774CAA48 00000000 7757D8B8 00000000 ...

*** 2026-08-13T17:03:31.561361+08:00 (CDB$ROOT(1))
Processing Oradebug command 'peek 0x00000000774c8668 544 1'
[0774C8668, 0774C8888) = 00000221 00B38F00 16B4E6AA 00000000 776E0728 ...
Dump of memory from 0x0774C867C to 0x0774C8888
0774C8670                            00000000              [....]
0774C8680 7757AB80 00000000 775805F0 00000000  [..Ww......Xw....]
0774C8690 774CAA48 00000000 7757D8B8 00000000  [H.Lw......Ww....]
0774C86A0 776E0DE0 00000000 776E3B18 00000000  [..nw.....;nw....]
0774C86B0 776E4750 00000000 77844890 00000000  [PGnw.....H.w....]
                            ~~~~~~~~~~~~~~~~~
0774C86C0 76A2E750 00000000 776E4750 00000000  [P..v....PGnw....]
0774C86D0 77844890 00000000 779AA300 00000000  [.H.w.......w....]
0774C86E0 779D6438 00000000 760DB990 00000000  [8d.w.......v....]
0774C86F0 760DA120 00000000 779D7B70 00000000  [ ..v....p{.w....]
0774C8700 779A49C8 00000000 760D47E8 00000000  [.I.w.....G.v....]
0774C8710 760CEEB0 00000000 767EC0B0 00000000  [...v......~v....]
0774C8720 7689C1E8 00000000 76A384F8 00000000  [...v.......v....]
0774C8730 769FC458 00000000 76A357C0 00000000  [X..v.....W.v....]
0774C8740 76A38660 00000000 76A28E18 00000000  [`..v.......v....]
0774C8750 76A0D000 00000000 76A12938 00000000  [...v....8).v....]
0774C8760 76A18270 00000000 76A1DBA8 00000000  [p..v.......v....]
0774C8770 76A234E0 00000000 760C3D78 00000000  [.4.v....x=.v....]
0774C8780 7624CCD8 00000000 762473A0 00000000  [..$v.....s$v....]
0774C8790 76266298 00000000 7624FA10 00000000  [.b&v......$v....]
0774C87A0 76252748 00000000 76255480 00000000  [H'%v.....T%v....]
0774C87B0 7625ADB8 00000000 76A3DF98 00000000  [..%v.......v....]
0774C87C0 76A40CD0 00000000 776E4750 00000000  [...v....PGnw....]
0774C87D0 7625DAF0 00000000 76260828 00000000  [..%v....(.&v....]
0774C87E0 76263560 00000000 76241930 00000000  [`5&v....0.$v....]
0774C87F0 760DBD88 00000000 760DEAC0 00000000  [...v.......v....]
0774C8800 760E17F8 00000000 76A2FE88 00000000  [...v.......v....]
0774C8810 779AA300 00000000 76A01D90 00000000  [...w.......v....]
0774C8820 76A076C8 00000000 760C1040 00000000  [.v.v....@..v....]
0774C8830 76244668 00000000 76A43A08 00000000  [hF$v.....:.v....]
0774C8840 76A44640 00000000 76A45278 00000000  [@F.v....xR.v....]
0774C8850 76A45EB0 00000000 760DAD58 00000000  [.^.v....X..v....]
0774C8860 7626BBD0 00000000 763CBD08 00000000  [..&v......<v....]
0774C8870 7652BE40 00000000 7694C320 00000000  [@.Rv.... ..v....]
0774C8880 7668BF78 00000000                    [x.hv....]
--//(544-16)/8  = 66,也就是存在66个地址。

--//如果直接查看文件61000000。
$ od -t x8 -j $[0x774C8668-0x61000000+0x10] -N $[544-16] -A x -w8 61000000 | nl -v 0 -ba
     0  164c8678 00000000776e0728
     1  164c8680 000000007757ab80
     2  164c8688 00000000775805f0
     3  164c8690 00000000774caa48
     4  164c8698 000000007757d8b8
     5  164c86a0 00000000776e0de0
     6  164c86a8 00000000776e3b18
     7  164c86b0 00000000776e4750
     8  164c86b8 0000000077844890
     9  164c86c0 0000000076a2e750
    10  164c86c8 00000000776e4750
    11  164c86d0 0000000077844890
    12  164c86d8 00000000779aa300
    13  164c86e0 00000000779d6438
    14  164c86e8 00000000760db990
    15  164c86f0 00000000760da120
    16  164c86f8 00000000779d7b70
    17  164c8700 00000000779a49c8
    18  164c8708 00000000760d47e8
    19  164c8710 00000000760ceeb0
    20  164c8718 00000000767ec0b0
    21  164c8720 000000007689c1e8
    22  164c8728 0000000076a384f8
    23  164c8730 00000000769fc458
    24  164c8738 0000000076a357c0
    25  164c8740 0000000076a38660
    26  164c8748 0000000076a28e18
    27  164c8750 0000000076a0d000
    28  164c8758 0000000076a12938
    29  164c8760 0000000076a18270
    30  164c8768 0000000076a1dba8
    31  164c8770 0000000076a234e0
    32  164c8778 00000000760c3d78
    33  164c8780 000000007624ccd8
    34  164c8788 00000000762473a0
    35  164c8790 0000000076266298
    36  164c8798 000000007624fa10
    37  164c87a0 0000000076252748
    38  164c87a8 0000000076255480
    39  164c87b0 000000007625adb8
    40  164c87b8 0000000076a3df98
    41  164c87c0 0000000076a40cd0
    42  164c87c8 00000000776e4750
    43  164c87d0 000000007625daf0
    44  164c87d8 0000000076260828
    45  164c87e0 0000000076263560
    46  164c87e8 0000000076241930
    47  164c87f0 00000000760dbd88
    48  164c87f8 00000000760deac0
    49  164c8800 00000000760e17f8
    50  164c8808 0000000076a2fe88
    51  164c8810 00000000779aa300
    52  164c8818 0000000076a01d90
    53  164c8820 0000000076a076c8
    54  164c8828 00000000760c1040
    55  164c8830 0000000076244668
    56  164c8838 0000000076a43a08
    57  164c8840 0000000076a44640
    58  164c8848 0000000076a45278
    59  164c8850 0000000076a45eb0
    60  164c8858 00000000760dad58
    61  164c8860 000000007626bbd0
    62  164c8868 00000000763cbd08
    63  164c8870 000000007652be40
    64  164c8878 000000007694c320
    65  164c8880 000000007668bf78
    66  164c8888
--//od 参数说明-t x8 8位一组,-j $[0x774C8668-0x61000000+0x10]表示开始位置,-N $[544-16]取长度,-A x表示文件偏移的16进
--//制显示,-w8显示宽度,相当于每行1个地址。

SYS@book> select min(CACHE#),max(cache#) from v$rowcache   order by 1 ;
MIN(CACHE#) MAX(CACHE#)
----------- -----------
          0          65

--//也就是这个row cache查询的起点(我猜测),比如查询dc_objects某个对象,知道cache#=8,对应的地址就是0x77844890(注意cache#从
--//0开始计数).

SYS@book> @ fchaz 77844890
LOC  KSMCHPTR          KSMCHIDX  KSMCHDUR KSMCHCOM                           KSMCHSIZ KSMCHCLS  KSMCHTYP KSMCHPAR         KSMCHPTR_BEGIN   KSMCHPTR_END+1
---- ---------------- --------- --------- -------------------------------- ---------- -------- --------- ---------------- ---------------- -----------------
VSGA 0000000077844880         1         1 row cache                               144 perm             0 0000000077004000 0000000077844880 0000000077844910

--//通过这个chunk就可以知道关联的相关地址.

SYS@book> @ opeek 0000000077844880 144 1
New tracefile_identifier = /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_3070_0002.trc
[077844880, 077844910) = 00000091 00B38F00 16B4E6AA 00000000 77844920 00000000 77844968 00000000 77844938 00000000 77844950 00000000 04200002 00010298 ...

*** 2026-08-13T17:16:51.628608+08:00 (CDB$ROOT(1))
Processing Oradebug command 'peek 0x0000000077844880 144 1'
[077844880, 077844910) = 00000091 00B38F00 16B4E6AA 00000000 77844920 ...
Dump of memory from 0x077844894 to 0x077844910
077844890          00000000 77844968 00000000      [....hI.w....]
0778448A0 77844938 00000000 77844950 00000000  [8I.w....PI.w....]
0778448B0 04200002 00010298 16B4E7B8 00000000  [.. .............]
0778448C0 0000000A 00000000 00008000 00000000  [................] --//0x00008000 = 32768
0778448D0 77844998 00000000 00000001 00000000  [.I.w............]
          ~~~~~~~~~~~~~~~~~
0778448E0 76A46B28 00000000 774C9058 00000000  [(k.v....X.Lw....]
0778448F0 00918700 00001D1B 77844980 00000000  [.........I.w....]
077844900 778C49A8 00000000 779849B8 00000000  [.I.w.....I.w....]
          ~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~
*** 2026-08-13T17:16:51.629138+08:00 (CDB$ROOT(1))

--//将上面下划线的地址减去0x10,就可以与如下KSMCHPTR
0x779849B8-0x10 = 0x00000000779849a8
0x778C49A8-0x10 = 0x00000000778c4998
0x77844998-0x10 = 0x0000000077844988

0x77844920-0x10 = 0x0000000077844910
0x77844968-0x10 = 0x0000000077844958
0x77844938-0x10 = 0x0000000077844928
0x77844950-0x10 = 0x0000000077844940
0x77844980-0x10 = 0x0000000077844970

--//单独拿cache_name='dc_objects' chunk看看,注我的测试环境每次重启该地址不会变化的,我没有修改sga相关配置:
SELECT a.*
      ,CASE
          WHEN ksmchcom = 'row cache mutex' AND MOD (KSMCHSIZ - 16, 24) = 0 THEN (KSMCHSIZ - 16) / 24
          WHEN ksmchcom = 'row cache mutex' AND MOD (KSMCHSIZ - 16, 24) <> 0 THEN (KSMCHSIZ - 16) / 4
          WHEN ksmchcom = 'row cache hash' AND MOD (KSMCHSIZ - 16, 16) = 0 THEN (KSMCHSIZ - 16) / 16
       END
          buckets
      ,a.KSMCHPTR KSMCHPTR_BEGIN
      ,TO_CHAR (TO_NUMBER (a.KSMCHPTR, 'XXXXXXXXXXXXXXXX') + a.KSMCHSIZ, 'FM0XXXXXXXXXXXXXXX') "KSMCHPTR_END+1"
  FROM x$ksmsp a
 WHERE KSMCHCOM LIKE 'row cache %' OR (KSMCHCOM = 'row cache' AND (KSMCHSIZ = 144 OR ksmchsiz = 24 or ksmchsiz=32));

ADDR                INDX  INST_ID CON_ID  KSMCHIDX  KSMCHDUR KSMCHCOM        KSMCHPTR           KSMCHSIZ KSMCHCLS  KSMCHTYP KSMCHPAR         BUCKETS KSMCHPTR_BEGIN   KSMCHPTR_END+1
---------------- ------- -------- ------ --------- --------- --------------- ---------------- ---------- -------- --------- ---------------- ------- ---------------- -----------------
00007F6035EE6E48  101140        1      1         1         1 row cache mutex 00000000779849A8     131088 perm             0 0000000077004000   32768 00000000779849A8 00000000779A49B8
00007F6035EE6DE0  101141        1      1         1         1 row cache mutex 00000000778C4998     786448 perm             0 0000000077004000   32768 00000000778C4998 00000000779849A8
00007F6035EE6D78  101142        1      1         1         1 row cache hash  0000000077844988     524304 perm             0 0000000077004000   32768 0000000077844988 00000000778C4998
00007F6035EE6D10  101143        1      1         1         1 row cache       0000000077844970         24 perm             0 0000000077004000         0000000077844970 0000000077844988
00007F6035EE6CA8  101144        1      1         1         1 row cache       0000000077844958         24 perm             0 0000000077004000         0000000077844958 0000000077844970
00007F6035EE6C40  101145        1      1         1         1 row cache       0000000077844940         24 perm             0 0000000077004000         0000000077844940 0000000077844958
00007F6035EE6BD8  101146        1      1         1         1 row cache       0000000077844928         24 perm             0 0000000077004000         0000000077844928 0000000077844940
00007F6035EE6B70  101147        1      1         1         1 row cache       0000000077844910         24 perm             0 0000000077004000         0000000077844910 0000000077844928
00007F6035EE6B08  101148        1      1         1         1 row cache       0000000077844880        144 perm             0 0000000077004000         0000000077844880 0000000077844910
--//许多地址都能对上。

--//疑问:前面测试查询如下
SYS@book> select rownum cache# from dual connect by level <=65 minus select cache# from v$rowcache where type='PARENT';
    CACHE#
----------
         7
        42
        51
        11
--//type='PARENT' 不存在cache#=7.42.51,11.
--//补充:
SYS@book> select distinct cache#,type,parameter  from v$rowcache where cache# in (7,11,42,51);
    CACHE# TYPE                           PARAMETER
---------- ------------------------------ ------------------------------
         7 SUBORDINATE                    dc_users
--//存在 CACHE#=7,TYPE=SUBORDINATE,PARAMETER=dc_users。在type='PARENT',PARAMETER=dc_users,cache#=10.
SYS@book> select distinct cache#,cache_name  from v$rowcache_parent where cache# in (7,11,42,51);
    CACHE# CACHE_NAME
---------- --------------
        11 dc_objects
--//有一部分CACHE_NAME=dc_objects,cache#=11,似乎这些对象在v$fixed_table定义。
--//另外单独写一篇blog分析.

3.验证偏移72位置表示buckets数量:
SYS@book> select 'oradebug peek 0x'||TO_CHAR (TO_NUMBER (KSMCHPTR, 'XXXXXXXXXXXXXXXX') + 72, 'FM0XXXXXXXXXXXXXXX')||' 4' c40 from x$ksmsp where KSMCHSIZ=144 and KSMCHCOM='row cache';

C40
----------------------------------------
oradebug peek 0x00000000779D7BA8 4
oradebug peek 0x00000000779D6470 4
oradebug peek 0x00000000779AA338 4
oradebug peek 0x00000000779A4A00 4
oradebug peek 0x00000000778448C8 4
oradebug peek 0x00000000776E4788 4
oradebug peek 0x00000000776E3B50 4
oradebug peek 0x00000000776E0E18 4
oradebug peek 0x00000000776E0760 4
oradebug peek 0x0000000077580628 4
oradebug peek 0x000000007757D8F0 4
oradebug peek 0x000000007757ABB8 4
oradebug peek 0x00000000774CAA80 4
oradebug peek 0x0000000076A45EE8 4
oradebug peek 0x0000000076A452B0 4
oradebug peek 0x0000000076A44678 4
oradebug peek 0x0000000076A43A40 4
oradebug peek 0x0000000076A40D08 4
oradebug peek 0x0000000076A3DFD0 4
oradebug peek 0x0000000076A38698 4
oradebug peek 0x0000000076A38530 4
oradebug peek 0x0000000076A357F8 4
oradebug peek 0x0000000076A2FEC0 4
oradebug peek 0x0000000076A2E788 4
oradebug peek 0x0000000076A28E50 4
oradebug peek 0x0000000076A23518 4
oradebug peek 0x0000000076A1DBE0 4
oradebug peek 0x0000000076A182A8 4
oradebug peek 0x0000000076A12970 4
oradebug peek 0x0000000076A0D038 4
oradebug peek 0x0000000076A07700 4
oradebug peek 0x0000000076A01DC8 4
oradebug peek 0x00000000769FC490 4
oradebug peek 0x000000007694C358 4
oradebug peek 0x000000007689C220 4
oradebug peek 0x00000000767EC0E8 4
oradebug peek 0x000000007668BFB0 4
oradebug peek 0x000000007652BE78 4
oradebug peek 0x00000000763CBD40 4
oradebug peek 0x000000007626BC08 4
oradebug peek 0x00000000762662D0 4
oradebug peek 0x0000000076263598 4
oradebug peek 0x0000000076260860 4
oradebug peek 0x000000007625DB28 4
oradebug peek 0x000000007625ADF0 4
oradebug peek 0x00000000762554B8 4
oradebug peek 0x0000000076252780 4
oradebug peek 0x000000007624FA48 4
oradebug peek 0x000000007624CD10 4
oradebug peek 0x00000000762473D8 4
oradebug peek 0x00000000762446A0 4
oradebug peek 0x0000000076241968 4
oradebug peek 0x00000000760E1830 4
oradebug peek 0x00000000760DEAF8 4
oradebug peek 0x00000000760DBDC0 4
oradebug peek 0x00000000760DB9C8 4
oradebug peek 0x00000000760DAD90 4
oradebug peek 0x00000000760DA158 4
oradebug peek 0x00000000760D4820 4
oradebug peek 0x00000000760CEEE8 4
oradebug peek 0x00000000760C3DB0 4
oradebug peek 0x00000000760C1078 4
62 rows selected.

--//执行如下.
spool bucket.txt
oradebug setmypid
--//拷贝粘贴以上内容
...
spool off

$ grep "^\[" bucket.txt | awk '{print $NF}' |  awk '{print strtonum("0x"$0)}'
65536                         
128
4096
512
32768
32768
64
256
32
32768
256
256
16384
64
64
64
64
256
256
512
1
256
512
128
512
512
512
512
512
512
512
512
512
16384
16384
16384
32768
32768
32768
32768
512
256
256
256
256
512
256
256
256
512
256
256
32768
256
256
16
64
64
512
512
1024
256

--//单独取select a.*,(KSMCHSIZ-16)/24 buckets from x$ksmsp a where KSMCHCOM='row cache mutex' and mod(KSMCHSIZ-16,24)=0 ;
--//输出的最后一列,适当编辑保存q6.txt

$ diff  <(grep "^\[" bucket.txt | awk '{print $NF}' |  awk '{print strtonum("0x"$0)}') q6.txt
--//完全正确.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/267265/viewspace-3180179/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    4006
  • 访问量
    7969275