B树索引的内部结构实验

SQL> create table dengzztest as select rownum a ,‘c’ c from dual connect by level<101;

表已创建。

SQL> create index dengzztest_idx on dengzztest(a);

索引已创建。

SQL> select object_id from user_objects where object_name=‘DENGZZTEST_IDX’;

OBJECT_ID

138274

SQL> alter session set events ‘immediate trace name treedump level 138274’;

会话已更改。
----- begin tree dump
leaf: 0x41b991 4307345 (0: nrow: 100 rrow: 100)
----- end tree dump
Leaf block dump

header address 541096028=0x2040785c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: opcode=0: iot flags=— is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 100
kdxcofbo 236=0xec
kdxcofeo 6836=0x1ab4
kdxcoavs 6600
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 02
col 1; len 6; (6): 00 41 b9 89 00 00
row#1[8012] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 03
col 1; len 6; (6): 00 41 b9 89 00 01
row#2[8000] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 04
col 1; len 6; (6): 00 41 b9 89 00 02
row#3[7988] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 05
col 1; len 6; (6): 00 41 b9 89 00 03
row#4[7976] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 06
col 1; len 6; (6): 00 41 b9 89 00 04
row#5[7964] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 07
col 1; len 6; (6): 00 41 b9 89 00 05
row#6[7952] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 08
col 1; len 6; (6): 00 41 b9 89 00 06
row#7[7940] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 09
col 1; len 6; (6): 00 41 b9 89 00 07
row#8[7928] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 0a
col 1; len 6; (6): 00 41 b9 89 00 08
row#9[7916] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 0b
col 1; len 6; (6): 00 41 b9 89 00 09
row#10[7904] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 0c
col 1; len 6; (6): 00 41 b9 89 00 0a
row#11[7892] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 0d
col 1; len 6; (6): 00 41 b9 89 00 0b
row#12[7880] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 0e
col 1; len 6; (6): 00 41 b9 89 00 0c
row#13[7868] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 0f
col 1; len 6; (6): 00 41 b9 89 00 0d
row#14[7856] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 10
col 1; len 6; (6): 00 41 b9 89 00 0e
row#15[7844] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 11
col 1; len 6; (6): 00 41 b9 89 00 0f
row#16[7832] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 12
col 1; len 6; (6): 00 41 b9 89 00 10
row#17[7820] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 13
col 1; len 6; (6): 00 41 b9 89 00 11
row#18[7808] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 14
col 1; len 6; (6): 00 41 b9 89 00 12
row#19[7796] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 15
col 1; len 6; (6): 00 41 b9 89 00 13
row#20[7784] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 16
col 1; len 6; (6): 00 41 b9 89 00 14
row#21[7772] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 17
col 1; len 6; (6): 00 41 b9 89 00 15
row#22[7760] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 18
col 1; len 6; (6): 00 41 b9 89 00 16
row#23[7748] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 19
col 1; len 6; (6): 00 41 b9 89 00 17
row#24[7736] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 1a
col 1; len 6; (6): 00 41 b9 89 00 18
row#25[7724] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 1b
col 1; len 6; (6): 00 41 b9 89 00 19
row#26[7712] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 1c
col 1; len 6; (6): 00 41 b9 89 00 1a
row#27[7700] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 1d
col 1; len 6; (6): 00 41 b9 89 00 1b
row#28[7688] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 1e
col 1; len 6; (6): 00 41 b9 89 00 1c
row#29[7676] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 1f
col 1; len 6; (6): 00 41 b9 89 00 1d
row#30[7664] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 20
col 1; len 6; (6): 00 41 b9 89 00 1e
row#31[7652] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 21
col 1; len 6; (6): 00 41 b9 89 00 1f
row#32[7640] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 22
col 1; len 6; (6): 00 41 b9 89 00 20
row#33[7628] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 23
col 1; len 6; (6): 00 41 b9 89 00 21
row#34[7616] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 24
col 1; len 6; (6): 00 41 b9 89 00 22
row#35[7604] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 25
col 1; len 6; (6): 00 41 b9 89 00 23
row#36[7592] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 26
col 1; len 6; (6): 00 41 b9 89 00 24
row#37[7580] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 27
col 1; len 6; (6): 00 41 b9 89 00 25
row#38[7568] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 28
col 1; len 6; (6): 00 41 b9 89 00 26
row#39[7556] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 29
col 1; len 6; (6): 00 41 b9 89 00 27
row#40[7544] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 2a
col 1; len 6; (6): 00 41 b9 89 00 28
row#41[7532] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 2b
col 1; len 6; (6): 00 41 b9 89 00 29
row#42[7520] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 2c
col 1; len 6; (6): 00 41 b9 89 00 2a
row#43[7508] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 2d
col 1; len 6; (6): 00 41 b9 89 00 2b
row#44[7496] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 2e
col 1; len 6; (6): 00 41 b9 89 00 2c
row#45[7484] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 2f
col 1; len 6; (6): 00 41 b9 89 00 2d
row#46[7472] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 30
col 1; len 6; (6): 00 41 b9 89 00 2e
row#47[7460] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 31
col 1; len 6; (6): 00 41 b9 89 00 2f
row#48[7448] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 32
col 1; len 6; (6): 00 41 b9 89 00 30
row#49[7436] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 33
col 1; len 6; (6): 00 41 b9 89 00 31
row#50[7424] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 34
col 1; len 6; (6): 00 41 b9 89 00 32
row#51[7412] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 35
col 1; len 6; (6): 00 41 b9 89 00 33
row#52[7400] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 36
col 1; len 6; (6): 00 41 b9 89 00 34
row#53[7388] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 37
col 1; len 6; (6): 00 41 b9 89 00 35
row#54[7376] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 38
col 1; len 6; (6): 00 41 b9 89 00 36
row#55[7364] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 39
col 1; len 6; (6): 00 41 b9 89 00 37
row#56[7352] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 3a
col 1; len 6; (6): 00 41 b9 89 00 38
row#57[7340] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 3b
col 1; len 6; (6): 00 41 b9 89 00 39
row#58[7328] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 3c
col 1; len 6; (6): 00 41 b9 89 00 3a
row#59[7316] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 3d
col 1; len 6; (6): 00 41 b9 89 00 3b
row#60[7304] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 3e
col 1; len 6; (6): 00 41 b9 89 00 3c
row#61[7292] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 3f
col 1; len 6; (6): 00 41 b9 89 00 3d
row#62[7280] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 40
col 1; len 6; (6): 00 41 b9 89 00 3e
row#63[7268] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 41
col 1; len 6; (6): 00 41 b9 89 00 3f
row#64[7256] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 42
col 1; len 6; (6): 00 41 b9 89 00 40
row#65[7244] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 43
col 1; len 6; (6): 00 41 b9 89 00 41
row#66[7232] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 44
col 1; len 6; (6): 00 41 b9 89 00 42
row#67[7220] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 45
col 1; len 6; (6): 00 41 b9 89 00 43
row#68[7208] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 46
col 1; len 6; (6): 00 41 b9 89 00 44
row#69[7196] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 47
col 1; len 6; (6): 00 41 b9 89 00 45
row#70[7184] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 48
col 1; len 6; (6): 00 41 b9 89 00 46
row#71[7172] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 49
col 1; len 6; (6): 00 41 b9 89 00 47
row#72[7160] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 4a
col 1; len 6; (6): 00 41 b9 89 00 48
row#73[7148] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 4b
col 1; len 6; (6): 00 41 b9 89 00 49
row#74[7136] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 4c
col 1; len 6; (6): 00 41 b9 89 00 4a
row#75[7124] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 4d
col 1; len 6; (6): 00 41 b9 89 00 4b
row#76[7112] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 4e
col 1; len 6; (6): 00 41 b9 89 00 4c
row#77[7100] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 4f
col 1; len 6; (6): 00 41 b9 89 00 4d
row#78[7088] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 50
col 1; len 6; (6): 00 41 b9 89 00 4e
row#79[7076] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 51
col 1; len 6; (6): 00 41 b9 89 00 4f
row#80[7064] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 52
col 1; len 6; (6): 00 41 b9 89 00 50
row#81[7052] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 53
col 1; len 6; (6): 00 41 b9 89 00 51
row#82[7040] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 54
col 1; len 6; (6): 00 41 b9 89 00 52
row#83[7028] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 55
col 1; len 6; (6): 00 41 b9 89 00 53
row#84[7016] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 56
col 1; len 6; (6): 00 41 b9 89 00 54
row#85[7004] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 57
col 1; len 6; (6): 00 41 b9 89 00 55
row#86[6992] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 58
col 1; len 6; (6): 00 41 b9 89 00 56
row#87[6980] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 59
col 1; len 6; (6): 00 41 b9 89 00 57
row#88[6968] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 5a
col 1; len 6; (6): 00 41 b9 89 00 58
row#89[6956] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 5b
col 1; len 6; (6): 00 41 b9 89 00 59
row#90[6944] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 5c
col 1; len 6; (6): 00 41 b9 89 00 5a
row#91[6932] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 5d
col 1; len 6; (6): 00 41 b9 89 00 5b
row#92[6920] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 5e
col 1; len 6; (6): 00 41 b9 89 00 5c
row#93[6908] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 5f
col 1; len 6; (6): 00 41 b9 89 00 5d
row#94[6896] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 60
col 1; len 6; (6): 00 41 b9 89 00 5e
row#95[6884] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 61
col 1; len 6; (6): 00 41 b9 89 00 5f
row#96[6872] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 62
col 1; len 6; (6): 00 41 b9 89 00 60
row#97[6860] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 63
col 1; len 6; (6): 00 41 b9 89 00 61
row#98[6848] flag: ------, lock: 0, len=12
col 0; len 2; (2): c1 64
col 1; len 6; (6): 00 41 b9 89 00 62
row#99[6836] flag: ------, lock: 0, len=12
col 0; len 2; (2): c2 02
col 1; len 6; (6): 00 41 b9 89 00 63
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 113041 maxblk 113041

col0 表示键值
col1 表示rowid

flag: -----, lock: 0表示索引