This page was saved using WebZIP 7.0.3.1030 offline browser (Unregistered) on 09/04/11 14:29:53.
Address: http://home2oracle.narod.ru/block_internal/6d.html
Title: 6.Trans data-index (leaf block)  •  Size: 360457  •  Last Modified: Thu, 04 Feb 2010 15:48:32 GMT
6   TRANS DATA (index\leaf block) extract data
 
  0 1 2 3 4 5 6 7 8 9 A B C D E F   Start dump data blocks tsn: 16 file#: 15 minblk 1795 maxblk 1795
00 061 022 003 004 03 07 C0 035 10 91 93 00 00 006 017 048   buffer tsn: 16 rdba: 0x03c00703 (15/1795)
10 C0 819 00 0010 0211 00 00 00 9B 7A 00 0012 07 91 93 00   Transaction scn: 0x0000.00939110 seq: 0x01 flg: 0x04 tail: 0x91100601
20 00 0013 00 00 0214 00 0215 0016 00 00 00 0017 00 00 00 00   header frmt: 0x02 chkval: 0x81c0 type: 0x06=trans data
30 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   ITL Block header dump:  0x03c00703
40 00 00 00 00 FF18 FF19 00 0020 00 00 00 0021 0022 00 00 0023    Object id on Block? Y
50 00 0024 0025 00 00 8026 00 0027 07 91 93 0028 0029 0030 8031 0232   Common  seg/obj: 0x7a9b  csc: 0x00.939107  itc: 2  flg: -  typ: 2 - INDEX
60 00 00 00 0033 2A 0034 78 0035 5C 0136 E4 0037 00 0038 00 0039    Index Header      fsl: 0  fnx: 0x0 ver: 0x01
70 04 07 C0 0340 00 00 00 0041 00 0042 00 00 64 0743 00 00   Leaf header  
80 4444 0745 24 07 FC 06 D4 06 B0 06 8C 06 6D 06 4E 06    Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
90 26 06 FE 05 DD 05 B5 05 8D 05 65 05 3D 05 19 05   0x01   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000
A0 F5 04 CD 04 A5 04 7F 04 59 04 33 04 0D 04 F0 03   Row directory 0x02   0xffff.000.00000000  0x00000000.0000.00  C---    0  scn 0x0000.00939107
B0 D3 03 AC 03 85 03 66 03 47 03 25 03 03 03 E0 02    
C0 BD 02 95 02 6D 02 45 02 1D 02 F5 01 CD 01 A8 01   Leaf block dump
D0 83 01 5C 01 1146 01 00 00 08 00 1B 00 CF 1F 00 00   ===============
E0 7C 00 80 00 B4 01 02 00 00 00 00 00 00 00 00 00   header address 63451228=0x3c8305c
F0 00 00 00 00 00 00 00 00 00 00 00 00 02 02 01 00   kdxcolev 0
100 06 91 93 00 00 00 00 00 01 02 00 00 06 91 93 00   KDXCOLEV Flags = - - -
110 02 02 00 00 A2 3C 93 00 00 00 00 00 00 00 00 00   kdxcolok 0
120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcoopc 0x80: opcode=0: iot flags=--- is converted=Y
130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   Free space kdxconco 2
140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcosdc 0
150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxconro 42
160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcofbo 120=0x78
170 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcofeo 348=0x15c
180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcoavs 228
190 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxlespl 0
1A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxlende 0
1B0 00 00 00 00 00 00 00 00 0047 00 1D 2F 31 30 62 37   kdxlenxt 62916356=0x3c00704
1C0 34 38 33 38 5F 53 65 63 75 72 69 74 79 4D 61 6E   kdxleprv 0=0x0
1D0 61 67 65 72 49 6D 70 6C 06 03 C0 00 23 00 04 0048   kdxledsz 0
1E0 00 1B 2F 31 30 61 37 39 33 66 64 5F 4C 6F 63 61   kdxlebksz 1892
1F0 6C 65 45 6C 65 6D 65 6E 74 73 5F 69 77 06 03 C0   row#0[1860] flag: -----, lock: 0
200 03 39 00 0E 0049 00 1B 2F 31 30 61 37 39 33 66 64   col 0; len 22; (22):
210 5F 4C 6F 63 61 6C 65 45 6C 65 6D 65 6E 74 73 5F    2f 31 30 30 35 62 64 33 30 5f 4c 6e 6b 64 43 6f 6e 73 74 61 6e 74
220 69 77 06 03 C0 00 23 00 03 0050 00 1E 2F 31 30 61   col 1; len 6; (6):  03 c0 00 22 00 00
230 34 35 62 66 65 5F 50 72 6F 66 69 6C 65 50 72 69   row#1[1828] flag: -----, lock: 0
240 6E 74 65 72 45 72 72 6F 72 73 06 03 C0 03 39 00   col 0; len 22; (22):
250 0D 0051 00 1E 2F 31 30 61 34 35 62 66 65 5F 50 72    2f 31 30 30 35 62 64 33 30 5f 4c 6e 6b 64 43 6f 6e 73 74 61 6e 74
260 6F 66 69 6C 65 50 72 69 6E 74 65 72 45 72 72 6F   col 1; len 6; (6):  03 c0 03 38 00 0b
270 72 73 06 03 C0 00 23 00 02 0052 00 1E 2F 31 30 39   row#2[1788] flag: -----, lock: 0
280 63 62 62 38 65 5F 53 70 61 6E 53 68 61 70 65 52   col 0; len 30; (30):
290 65 6E 64 65 72 65 72 53 69 6D 06 03 C0 03 39 00    2f 31 30 30 37 36 62 32 33 5f 4f 72 61 43 75 73 74 6f 6d 44 61 74 75 6d 43
2A0 0C 0053 00 1E 2F 31 30 39 63 62 62 38 65 5F 53 70    6c 6f 73 75 72
2B0 61 6E 53 68 61 70 65 52 65 6E 64 65 72 65 72 53   col 1; len 6; (6):  03 c0 00 22 00 01
2C0 69 6D 06 03 C0 00 23 00 01 0054 00 1E 2F 31 30 39   row#3[1748] flag: -----, lock: 0
2D0 61 32 38 34 62 5F 4F 72 61 63 6C 65 58 4D 4C 53   col 0; len 30; (30):
2E0 74 61 74 69 63 51 75 65 72 79 06 03 C0 03 39 00    2f 31 30 30 37 36 62 32 33 5f 4f 72 61 43 75 73 74 6f 6d 44 61 74 75 6d 43
2F0 0B 0055 00 1E 2F 31 30 39 61 32 38 34 62 5F 4F 72    6c 6f 73 75 72
300 61 63 6C 65 58 4D 4C 53 74 61 74 69 63 51 75 65   col 1; len 6; (6):  03 c0 03 38 00 0c
310 72 79 06 03 C0 00 23 00 00 0056 0057 1958 2F 31 30 39   Row data row#4[1712] flag: -----, lock: 0
320 35 63 65 39 62 5F 4D 75 6C 74 69 43 6F 6D 62 6F   col 0; len 26; (26):
330 42 6F 78 55 4959 0660 03 C0 03 39 00 0A61 0062 0063 1964 2F    2f 31 30 32 35 33 30 38 66 5f 53 75 6e 54 69 6c 65 53 63 68 65 64 75 6c 65
340 31 30 39 35 63 65 39 62 5F 4D 75 6C 74 69 43 6F    72
350 6D 62 6F 42 6F 78 55 4965 0666 03 C0 03 39 00 0F67 0068   col 1; len 6; (6):  03 c0 03 38 00 0d
360 00 18 2F 31 30 39 34 38 64 63 33 5F 50 65 72 6D   row#5[1676] flag: -----, lock: 0
370 69 73 73 69 6F 6E 49 6D 70 6C 06 03 C0 03 39 00   col 0; len 26; (26):
380 09 0069 00 18 2F 31 30 39 34 38 64 63 33 5F 50 65    2f 31 30 32 35 33 30 38 66 5f 53 75 6e 54 69 6c 65 53 63 68 65 64 75 6c 65
390 72 6D 69 73 73 69 6F 6E 49 6D 70 6C 06 03 C0 00    72
3A0 22 00 0E 0070 00 15 2F 31 30 38 34 35 33 32 30 5F   col 1; len 6; (6):  03 c0 06 2c 00 10
3B0 54 79 70 65 4D 61 70 49 6D 70 6C 06 03 C0 03 39   row#6[1645] flag: -----, lock: 0
3C0 00 08 0071 00 15 2F 31 30 38 34 35 33 32 30 5F 54   col 0; len 21; (21):
3D0 79 70 65 4D 61 70 49 6D 70 6C 06 03 C0 00 22 00    2f 31 30 32 39 37 63 39 31 5f 53 41 58 41 74 74 72 4c 69 73 74
3E0 0D 0072 00 1D 2F 31 30 38 33 34 33 66 36 5F 4D 75   col 1; len 6; (6):  03 c0 00 22 00 02
3F0 6C 74 69 43 6F 6C 6F 72 43 68 6F 6F 73 65 72 55   row#7[1614] flag: -----, lock: 0
400 49 06 03 C0 03 39 00 07 0073 00 1D 2F 31 30 38 33   col 0; len 21; (21):
410 34 33 66 36 5F 4D 75 6C 74 69 43 6F 6C 6F 72 43    2f 31 30 32 39 37 63 39 31 5f 53 41 58 41 74 74 72 4c 69 73 74
420 68 6F 6F 73 65 72 55 49 06 03 C0 00 22 00 0C 0074   col 1; len 6; (6):  03 c0 03 38 00 0e
430 00 13 2F 31 30 38 30 34 61 65 37 5F 43 6F 6E 73   row#8[1574] flag: -----, lock: 0
440 74 61 6E 74 73 06 03 C0 03 39 00 06 0075 00 13 2F   col 0; len 30; (30):
450 31 30 38 30 34 61 65 37 5F 43 6F 6E 73 74 61 6E    2f 31 30 33 61 32 65 37 33 5f 44 65 66 61 75 6c 74 45 64 69 74 6f 72 4b 69
460 74 73 06 03 C0 00 22 00 0B 0076 00 1C 2F 31 30 37    74 45 6e 64 50
470 39 63 39 34 64 5F 4E 75 6D 62 65 72 43 6F 6E 73   col 1; len 6; (6):  03 c0 00 22 00 03
480 74 61 6E 74 44 61 74 61 06 03 C0 03 39 00 05 0077   row#9[1534] flag: -----, lock: 0
490 00 1C 2F 31 30 37 39 63 39 34 64 5F 4E 75 6D 62   col 0; len 30; (30):
4A0 65 72 43 6F 6E 73 74 61 6E 74 44 61 74 61 06 03    2f 31 30 33 61 32 65 37 33 5f 44 65 66 61 75 6c 74 45 64 69 74 6f 72 4b 69
4B0 C0 00 22 00 0A 0078 00 1C 2F 31 30 37 34 34 38 33    74 45 6e 64 50
4C0 37 5F 4F 62 6A 65 63 74 53 74 72 65 61 6D 43 6C   col 1; len 6; (6):  03 c0 03 38 00 0f
4D0 61 73 73 32 06 03 C0 03 39 00 04 0079 00 1C 2F 31   row#10[1501] flag: -----, lock: 0
4E0 30 37 34 34 38 33 37 5F 4F 62 6A 65 63 74 53 74   col 0; len 23; (23):
4F0 72 65 61 6D 43 6C 61 73 73 32 06 03 C0 00 22 00    2f 31 30 34 38 37 33 34 66 5f 44 65 66 61 75 6c 74 46 6f 6c 64 65 72
500 09 0080 00 1E 2F 31 30 36 66 61 61 62 63 5F 42 61   col 1; len 6; (6):  03 c0 00 22 00 04
510 73 69 63 54 72 65 65 55 49 4B 65 79 48 61 6E 64   row#11[1461] flag: -----, lock: 0
520 6C 65 06 03 C0 03 39 00 03 0081 00 1E 2F 31 30 36   col 0; len 30; (30):
530 66 61 61 62 63 5F 42 61 73 69 63 54 72 65 65 55    2f 31 30 35 30 31 39 30 32 5f 42 61 73 69 63 46 69 6c 65 43 68 6f 6f 73 65
540 49 4B 65 79 48 61 6E 64 6C 65 06 03 C0 00 22 00    72 55 49 4e 65
550 08 0082 00 1A 2F 31 30 36 62 61 30 61 35 5F 41 72   col 1; len 6; (6):  03 c0 00 22 00 05
560 72 61 79 45 6E 75 6D 65 72 61 74 69 6F 6E 06 03   row#12[1421] flag: -----, lock: 0
570 C0 03 39 00 02 0083 00 1A 2F 31 30 36 62 61 30 61   col 0; len 30; (30):
580 35 5F 41 72 72 61 79 45 6E 75 6D 65 72 61 74 69    2f 31 30 35 30 31 39 30 32 5f 42 61 73 69 63 46 69 6c 65 43 68 6f 6f 73 65
590 6F 6E 06 03 C0 00 22 00 07 0084 00 1E 2F 31 30 35    72 55 49 4e 65
5A0 30 37 32 65 37 5F 48 74 74 70 53 65 73 73 69 6F   col 1; len 6; (6):  03 c0 03 39 00 00
5B0 6E 42 69 6E 64 69 6E 67 45 76 06 03 C0 03 39 00   row#13[1381] flag: -----, lock: 0
5C0 01 0085 00 1E 2F 31 30 35 30 37 32 65 37 5F 48 74   col 0; len 30; (30):
5D0 74 70 53 65 73 73 69 6F 6E 42 69 6E 64 69 6E 67    2f 31 30 35 30 37 32 65 37 5f 48 74 74 70 53 65 73 73 69 6f 6e 42 69 6e 64
5E0 45 76 06 03 C0 00 22 00 06 0086 00 1E 2F 31 30 35    69 6e 67 45 76
5F0 30 31 39 30 32 5F 42 61 73 69 63 46 69 6C 65 43   col 1; len 6; (6):  03 c0 00 22 00 06
600 68 6F 6F 73 65 72 55 49 4E 65 06 03 C0 03 39 00   row#14[1341] flag: -----, lock: 0
610 00 0087 00 1E 2F 31 30 35 30 31 39 30 32 5F 42 61   col 0; len 30; (30):
620 73 69 63 46 69 6C 65 43 68 6F 6F 73 65 72 55 49    2f 31 30 35 30 37 32 65 37 5f 48 74 74 70 53 65 73 73 69 6f 6e 42 69 6e 64
630 4E 65 06 03 C0 00 22 00 05 0088 00 17 2F 31 30 34    69 6e 67 45 76
640 38 37 33 34 66 5F 44 65 66 61 75 6C 74 46 6F 6C   col 1; len 6; (6):  03 c0 03 39 00 01
650 64 65 72 06 03 C0 00 22 00 04 0089 00 1E 2F 31 30   row#15[1305] flag: -----, lock: 0
660 33 61 32 65 37 33 5F 44 65 66 61 75 6C 74 45 64   col 0; len 26; (26):
670 69 74 6F 72 4B 69 74 45 6E 64 50 06 03 C0 03 38    2f 31 30 36 62 61 30 61 35 5f 41 72 72 61 79 45 6e 75 6d 65 72 61 74 69 6f
680 00 0F 0090 00 1E 2F 31 30 33 61 32 65 37 33 5F 44    6e
690 65 66 61 75 6C 74 45 64 69 74 6F 72 4B 69 74 45   col 1; len 6; (6):  03 c0 00 22 00 07
6A0 6E 64 50 06 03 C0 00 22 00 03 0091 00 15 2F 31 30   row#16[1269] flag: -----, lock: 0
6B0 32 39 37 63 39 31 5F 53 41 58 41 74 74 72 4C 69   col 0; len 26; (26):
6C0 73 74 06 03 C0 03 38 00 0E 0092 00 15 2F 31 30 32    2f 31 30 36 62 61 30 61 35 5f 41 72 72 61 79 45 6e 75 6d 65 72 61 74 69 6f
6D0 39 37 63 39 31 5F 53 41 58 41 74 74 72 4C 69 73    6e
6E0 74 06 03 C0 00 22 00 02 0093 00 1A 2F 31 30 32 35   col 1; len 6; (6):  03 c0 03 39 00 02
6F0 33 30 38 66 5F 53 75 6E 54 69 6C 65 53 63 68 65   row#17[1229] flag: -----, lock: 0
700 64 75 6C 65 72 06 03 C0 06 2C 00 10 0094 00 1A 2F   col 0; len 30; (30):
710 31 30 32 35 33 30 38 66 5F 53 75 6E 54 69 6C 65    2f 31 30 36 66 61 61 62 63 5f 42 61 73 69 63 54 72 65 65 55 49 4b 65 79 48
720 53 63 68 65 64 75 6C 65 72 06 03 C0 03 38 00 0D    61 6e 64 6c 65
730 0095 00 1E 2F 31 30 30 37 36 62 32 33 5F 4F 72 61   col 1; len 6; (6):  03 c0 00 22 00 08
740 43 75 73 74 6F 6D 44 61 74 75 6D 43 6C 6F 73 75   row#18[1189] flag: -----, lock: 0
750 72 06 03 C0 03 38 00 0C 0096 00 1E 2F 31 30 30 37   col 0; len 30; (30):
760 36 62 32 33 5F 4F 72 61 43 75 73 74 6F 6D 44 61    2f 31 30 36 66 61 61 62 63 5f 42 61 73 69 63 54 72 65 65 55 49 4b 65 79 48
770 74 75 6D 43 6C 6F 73 75 72 06 03 C0 00 22 00 01    61 6e 64 6c 65
780 0097 00 16 2F 31 30 30 35 62 64 33 30 5F 4C 6E 6B   col 1; len 6; (6):  03 c0 03 39 00 03
790 64 43 6F 6E 73 74 61 6E 74 06 03 C0 03 38 00 0B   row#19[1151] flag: -----, lock: 0
7A0 0098 00 16 2F 31 30 30 35 62 64 33 30 5F 4C 6E 6B   col 0; len 28; (28):
7B0 64 43 6F 6E 73 74 61 6E 74 06 03 C0 00 22 00 00    2f 31 30 37 34 34 38 33 37 5f 4f 62 6a 65 63 74 53 74 72 65 61 6d 43 6c 61
7C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    73 73 32
7D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 1; len 6; (6):  03 c0 00 22 00 09
7E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   row#20[1113] flag: -----, lock: 0
7F0 00 00 00 00 00 00 00 00 00 00 00 00 01 06 10 9199   col 0; len 28; (28):
 2f 31 30 37 34 34 38 33 37 5f 4f 62 6a 65 63 74 53 74 72 65 61 6d 43 6c 61
 73 73 32
 SQL>select dbms_utility.data_block_address_file(62916355)as file_, col 1; len 6; (6):  03 c0 03 39 00 04
dbms_utility.data_block_address_block(62916355) as  block_ from dual;  
row#21[1075] flag: -----, lock: 0
FILE_     BLOCK_     col 0; len 28; (28):
15 1795  2f 31 30 37 39 63 39 34 64 5f 4e 75 6d 62 65 72 43 6f 6e 73 74 61 6e 74 44
 61 74 61
SQL> alter system dump datafile 15  block 1795; col 1; len 6; (6):  03 c0 00 22 00 0a
SQL> alter system checkpoint; row#22[1037] flag: -----, lock: 0
col 0; len 28; (28):
 2f 31 30 37 39 63 39 34 64 5f 4e 75 6d 62 65 72 43 6f 6e 73 74 61 6e 74 44
alter session set events 'immediate trace name treedump level 31387'                                      61 74 61
 ----- begin tree dump col 1; len 6; (6):  03 c0 03 39 00 05
branch: 0x3c00702 62916354 (0: nrow: 9, level: 2) row#23[1008] flag: -----, lock: 0
   branch: 0x3c0074d 62916429 (-1: nrow: 73, level: 1) col 0; len 19; (19):  2f 31 30 38 30 34 61 65 37 5f 43 6f 6e 73 74 61 6e 74 73
      leaf: 0x3c00703 62916355 (-1: nrow: 42 rrow: 42) col 1; len 6; (6):  03 c0 00 22 00 0b
      leaf: 0x3c00704 62916356 (0: nrow: 40 rrow: 40) row#24[979] flag: -----, lock: 0
……………………………………………………………………………….. col 0; len 19; (19):  2f 31 30 38 30 34 61 65 37 5f 43 6f 6e 73 74 61 6e 74 73
      leaf: 0x3c0074b 62916427 (71: nrow: 43 rrow: 43) col 1; len 6; (6):  03 c0 03 39 00 06
   branch: 0x3c0079f 62916511 (0: nrow: 81, level: 1) row#25[940] flag: -----, lock: 0
……………………………………………………………………………….. col 0; len 29; (29):
 ----- end tree dump  2f 31 30 38 33 34 33 66 36 5f 4d 75 6c 74 69 43 6f 6c 6f 72 43 68 6f 6f 73
 65 72 55 49
col 1; len 6; (6):  03 c0 00 22 00 0c
row#26[901] flag: -----, lock: 0
col 0; len 29; (29):
 2f 31 30 38 33 34 33 66 36 5f 4d 75 6c 74 69 43 6f 6c 6f 72 43 68 6f 6f 73
 65 72 55 49
col 1; len 6; (6):  03 c0 03 39 00 07
row#27[870] flag: -----, lock: 0
col 0; len 21; (21):
 2f 31 30 38 34 35 33 32 30 5f 54 79 70 65 4d 61 70 49 6d 70 6c
col 1; len 6; (6):  03 c0 00 22 00 0d
row#28[839] flag: -----, lock: 0
col 0; len 21; (21):
 2f 31 30 38 34 35 33 32 30 5f 54 79 70 65 4d 61 70 49 6d 70 6c
col 1; len 6; (6):  03 c0 03 39 00 08
row#29[805] flag: -----, lock: 0
col 0; len 24; (24):
 2f 31 30 39 34 38 64 63 33 5f 50 65 72 6d 69 73 73 69 6f 6e 49 6d 70 6c
col 1; len 6; (6):  03 c0 00 22 00 0e
row#30[771] flag: -----, lock: 0
col 0; len 24; (24):
 2f 31 30 39 34 38 64 63 33 5f 50 65 72 6d 69 73 73 69 6f 6e 49 6d 70 6c
col 1; len 6; (6):  03 c0 03 39 00 09
row#31[736] flag: -----, lock: 0
col 0; len 25; (25):
 2f 31 30 39 35 63 65 39 62 5f 4d 75 6c 74 69 43 6f 6d 62 6f 42 6f 78 55 49
col 1; len 6; (6):  03 c0 00 22 00 0f
row#32[701] flag: -----, lock: 0
col 0; len 25; (25):
 2f 31 30 39 35 63 65 39 62 5f 4d 75 6c 74 69 43 6f 6d 62 6f 42 6f 78 55 49
col 1; len 6; (6):  03 c0 03 39 00 0a
row#33[661] flag: -----, lock: 0
col 0; len 30; (30):
 2f 31 30 39 61 32 38 34 62 5f 4f 72 61 63 6c 65 58 4d 4c 53 74 61 74 69 63
 51 75 65 72 79
col 1; len 6; (6):  03 c0 00 23 00 00
row#34[621] flag: -----, lock: 0
col 0; len 30; (30):
 2f 31 30 39 61 32 38 34 62 5f 4f 72 61 63 6c 65 58 4d 4c 53 74 61 74 69 63
 51 75 65 72 79
col 1; len 6; (6):  03 c0 03 39 00 0b
row#35[581] flag: -----, lock: 0
col 0; len 30; (30):
 2f 31 30 39 63 62 62 38 65 5f 53 70 61 6e 53 68 61 70 65 52 65 6e 64 65 72
 65 72 53 69 6d
col 1; len 6; (6):  03 c0 00 23 00 01
row#36[541] flag: -----, lock: 0
col 0; len 30; (30):
 2f 31 30 39 63 62 62 38 65 5f 53 70 61 6e 53 68 61 70 65 52 65 6e 64 65 72
 65 72 53 69 6d
col 1; len 6; (6):  03 c0 03 39 00 0c
row#37[501] flag: -----, lock: 0
col 0; len 30; (30):
 2f 31 30 61 34 35 62 66 65 5f 50 72 6f 66 69 6c 65 50 72 69 6e 74 65 72 45
 72 72 6f 72 73
col 1; len 6; (6):  03 c0 00 23 00 02
row#38[461] flag: -----, lock: 0
col 0; len 30; (30):
 2f 31 30 61 34 35 62 66 65 5f 50 72 6f 66 69 6c 65 50 72 69 6e 74 65 72 45
 72 72 6f 72 73
col 1; len 6; (6):  03 c0 03 39 00 0d
row#39[424] flag: -----, lock: 0
col 0; len 27; (27):
 2f 31 30 61 37 39 33 66 64 5f 4c 6f 63 61 6c 65 45 6c 65 6d 65 6e 74 73 5f
 69 77
col 1; len 6; (6):  03 c0 00 23 00 03
row#40[387] flag: -----, lock: 0
col 0; len 27; (27):
 2f 31 30 61 37 39 33 66 64 5f 4c 6f 63 61 6c 65 45 6c 65 6d 65 6e 74 73 5f
 69 77
col 1; len 6; (6):  03 c0 03 39 00 0e
row#41[348] flag: -----, lock: 0
col 0; len 29; (29):
 2f 31 30 62 37 34 38 33 38 5f 53 65 63 75 72 69 74 79 4d 61 6e 61 67 65 72
 49 6d 70 6c
col 1; len 6; (6):  03 c0 00 23 00 04
----- end of leaf block dump -----
End dump data blocks tsn: 16 file#: 15 minblk 1795 maxblk 1795
EXEC #2:c=140625,e=370022,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=4758521747
XCTEND rlbk=0, rd_only=1
XCTEND rlbk=1, rd_only=1
1
Block types.
type:0x06
2
The format of the cache header was changed for Oracle8. Under Oracle8 and 9, the value is always 2. Previously, it was 1.
frmt:0x02
3
spare1
4
spare2
5
The tablespace relative database block address (RDBA). This is constructed from the tablespace relative file
number (10 bits), and the block number of the data block within that file (22 bits).
RDBA:0x3C00703
6
The SCN at which the block was last changed. The low-order 4 bytes are called the SCN base, and the high-order
2 bytes are called the SCN wrap.
scn: 0x0000.00939110
7
A sequence number incremented for each change to a block at the same SCN. If the sequence
number wraps, a new SCN must be allocated.  The value 0xff is reserved. When present it
indicates that the block has been marked as corrupt by Oracle.
seq:0x01
8
Flag.
1 - virgin block
2 - last change to the block was for a cleanout operation
4 - checksum value is set
8 - temporary data
flg:0x04
9
An optional checksum of the block contents. When a block is written, the checksum is either cleared or set depending on the
setting of the db_block_checksum parameter. When a block is read, the checksum is verified if present and if the parameter is set
to TRUE. Checksums are always calculated and checked for blocks in the SYSTEM tablespace. The checksum is the XOR of all the
other 2-byte pairs in the block. Thus when a block with a checksum is checked, the XOR of all the 2-byte words in the block should be 0.
chkval:0x81C0
10
spare3
11
Flag for data or index block.
 1 - Data
 2 - Index
 type:02
12
The object number of the segment in OBJ$.
  seg/obj: 0x00007A9B (31387)
13
Cleanout system change,used to show when block cleanout was last performed.
 csc: 0x00939107
14
Count of the ITLs on the block.
 itc:2
15
Flag (no ASSM) :
'-' means that the block is not on the freelist,
'O' - in freelist
Object id on Block? Y flg: - ver: 0x01
???
16
Index to the first slot on the ITL freelist.
 fsl:0
17
The RDBA of the next block on the segment freelist.Null if this block is not on a freelist. 
fnx: 0x00000000
18
The ITL is used to mark the row locked until the transaction completes.
XID is  the  pointer to the rollback segment transaction table slot  -  Undoseg#.slot#.wrap
The  Undoseg# is the rollback segment, the slot# refers to  a slot in trunsaction  table, and  wrap refers to the number of times that the
slot has been used  in  a trunsaction.
0xFFFF.0000.00000000
19
Rollback segment
XID:undoseg
20
Refers to a slot in the transaction table XID:slot#
21
Refers to the number of times that the slot has been used (i.e. incarnation or version) in a transaction.
XID:wrap
22
The UBA is the pointer to the tail of the undo chain for the block.
UBA:(undodatablockaddr.sequence#.record#):   0x00000000.0000.00
23
DBA of the rollback segment
24
Sequence number
25
Record number for the change in that undo block
26
Lck Flag
---- transaction is active, or committed pending cleanout    
C--- transaction has been committed and locks cleaned out  
-B-- this undo record contains the undo for this ITL entry   
--U- transaction committed (maybe long ago); SCN is an upper bound   
---T = transaction was still active at block cleanout SCN  
Lck Flag: C---
Lck
The number of row-level locks held in the block by this transaction
Lck: 0
(1000 - 0000 0000 0000)
27
If the transaction has been cleaned out, this is the commit SCN or an upper bound thereof. Otherwise the leading two
bytes contain the free space credit for the transaction - that is, the number of bytes freed in the block by the transaction
(free space credit) Fsc:0
28
SCN or freespace credit.
If the transaction has been cleaned out, this is the commit SCN or an upper bound thereof. Otherwise the leading two bytes contain the free space credit for
the transaction - that is, the number of bytes freed in the block by the transaction.
(SCN of commited TX ) Scn/Fsc: 0x00939107
29
Index level (0 represents leaf blocks).
kdxcolev: 0
30
Denotes whether structural block transaction is occurring.
kdxcolok:0
31
Internal operation code.
kdxcoopc: 0x80:  opcode=0: iot flags=--- is converted=Y
32
Iindex column count.
kdxconco:2
33
Ccount of index structural changes involving lock.
kdxcosdc:0
34
Number of index entries -does not include kdxbrlmc pointer.
 kdxconro:42
35
Free space begin offset. kdxcofbo:0x0078
36
Free space end offset. kdxcofeo:0x015C
37
Available space in the block.
kdxcoavs:228
38
 Bytes of uncommitted data at time of block split that have been cleaned out.
 kdxlespl:0
39
Nnumber of deleted entries.
 kdxlende:0
40
Pointer to the next leaf block in the index structure via corresponding RDBA .
kdxlenxt: 0x03C00704
41
Pointer to the previous leaf block in the index structure via corresponding RDBA.
 kdxleprv: 0x00000000
42
Usable block space (by default less than branch due to the additional ITL entry). kdxledsz:0
43
kdxlebksz:1892
44
 Begin data row address.
45
offset @0x744 (1860)
46
 Begin free space.
47
row =41
48
row =40
49
row =39
50
row =38
51
row =37
52
row =36
53
row =35
54
row =34
55
row =33
56
row =32
flag: -----
57
Lock byte.
Corresponds with above ITL lck expresses this line whether by lock.
lb: 0x0
58
len 25
59
"/1095ce9b_MultiComboBoxUI"
60
len 6
61
ROWID
0x3c0033900.a
file - 15
block -825
row - 10
62
row =31
flag: -----
63
Lock byte.
Corresponds with above ITL lck expresses this line whether by lock
lb: 0x0
64
len 25
65
"/1095ce9b_MultiComboBoxUI"
66
len 6
67
ROWID
0x3c0033900.f
file - 15
block - 34
row - 15
68
row =30
69
row =29
70
row =28
71
row =27
72
row =26
73
row =25
74
row =24
75
row =23
76
row =22
77
row =21
78
row =20
79
row =19
80
row =18
81
row =17
82
row =16
83
row =15
84
row =14
85
row =13
86
row =12
87
row =11
88
row =10
89
row =9
90
row =8
91
row =7
92
row =6
93
row =5
94
row =4
95
row =3
96
row =2
97
row =1
98
row =0
99
Tail is comprised of the low-order two bytes of the SCN base followed by the block type and the sequence number. The consistency of the
header and tail is checked whenever a block is read. This detects most block corruptions, in particular split blocks from hot backups.
tail:0x91100601