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/6a.html
Title: 6.Trans data-heap table  •  Size: 383915  •  Last Modified: Thu, 04 Feb 2010 15:48:32 GMT
6 TRANS DATA (heap-table) 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 34 maxblk 34
00 061 022 003 004 22 00 C0 035 36 23 93 00 00 006 017 048   buffer tsn: 16 rdba: 0x03c00022 (15/34)
10 35 5B9 00 0010 0111 00 00 00 93 7A 00 0012 05 23 93 00   Transaction scn: 0x0000.00932336 seq: 0x01 flg: 0x04 tail: 0x23360601
20 00 0013 00 00 0314 00 0215 0016 00 00 00 0017 FF18 FF19 00 0020   header frmt: 0x02 chkval: 0x5b35 type: 0x06=trans data
30 00 00 00 0021 0022 00 00 0023 00 0024 0025 00 00 8026 00 0027   Block header dump: 0x03c00022
40 05 23 93 0028 00 00 00 00 00 00 00 00 00 00 00 00   ITL Object id on Block? Y
50 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   seg/obj: 0x7a93 csc: 0x00.932305 itc: 3 flg: - typ: 1 - DATA
60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   fsl: 0 fnx: 0x0 ver: 0x01
70 00 00 00 00 0029 0130 10 0031 FF FF32 32 0033 4D 0134 1B 0135  
80 1B 0136 00 0037 10 0038 2839 0740 C1 06 62 06 FA 05 99 05   Table directory Itl Xid Uba Flag Lck Scn/Fsc
90 31 05 C9 04 65 04 FE 03 98 03 32 03 D6 02 6F 02   Row directory 0x01 0xffff.000.00000000 0x00000000.0000.00 C--- 0 scn 0x0000.00932305
A0 11 02 B0 01 4D 0141 0042 00 00 00 00 00 00 00 00 00   0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   0x03 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  
D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   data_block_dump,data header at 0x5e63074
E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   ===============
F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   tsiz: 0x788
100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   hsiz: 0x32
110 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   pbl: 0x05e63074
120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   Free space bdba: 0x03c00022
130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   76543210
140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   flag=--------
150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   ntab=1
160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   nrow=16
170 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   frre=-1
180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   fsbo=0x32
190 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   fseo=0x14d
1A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   avsp=0x11b
1B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   tosp=0x11b
1C0 00 2C43 0044 0D45 0346 53 59 5347 1948 2F 31 30 39 35 63 65   0xe:pti[0] nrow=16 offs=0
1D0 39 62 5F 4D 75 6C 74 69 43 6F 6D 62 6F 42 6F 78   0x12:pri[0] offs=0x728
1E0 55 4949 FF50 0451 C3 02 58 4952 FF53 0A54 4A 41 56 41 20 43   0x14:pri[1] offs=0x6c1
1F0 4C 41 53 5355 0756 78 66 05 0C 11 34 3A57 0758 78 66 05   0x16:pri[2] offs=0x662
200 0C 11 34 3A59 1360 32 30 30 32 2D 30 35 2D 31 32 3A   0x18:pri[3] offs=0x5fa
210 31 36 3A 35 31 3A 35 3761 0562 56 41 4C 49 4463 0164 4E65   0x1a:pri[4] offs=0x599
220 0166 4E67 0168 4E69 2C70 00 0D 03 53 59 53 18 2F 31 30 39   0x1c:pri[5] offs=0x531
230 34 38 64 63 33 5F 50 65 72 6D 69 73 73 69 6F 6E   0x1e:pri[6] offs=0x4c9
240 49 6D 70 6C FF 03 C2 40 48 FF 0A 4A 41 56 41 20   0x20:pri[7] offs=0x465
250 43 4C 41 53 53 07 78 66 05 0C 11 30 23 07 78 66   0x22:pri[8] offs=0x3fe
260 05 0C 11 30 23 13 32 30 30 32 2D 30 35 2D 31 32   0x24:pri[9] offs=0x398
270 3A 31 36 3A 34 37 3A 33 34 05 56 41 4C 49 44 01   0x26:pri[10] offs=0x332
280 4E 01 4E 01 4E 2C71 00 0D 03 53 59 53 15 2F 31 30   0x28:pri[11] offs=0x2d6
290 38 34 35 33 32 30 5F 54 79 70 65 4D 61 70 49 6D   0x2a:pri[12] offs=0x26f
2A0 70 6C FF 03 C2 5D 32 FF 0A 4A 41 56 41 20 43 4C   0x2c:pri[13] offs=0x211
2B0 41 53 53 07 78 66 05 0C 11 31 27 07 78 66 05 0C   0x2e:pri[14] offs=0x1b0
2C0 11 31 27 13 32 30 30 32 2D 30 35 2D 31 32 3A 31   0x30:pri[15] offs=0x14d
2D0 36 3A 34 38 3A 33 38 05 56 41 4C 49 44 01 4E 01   block_row_dump:
2E0 4E 01 4E 2C72 00 0D 03 53 59 53 1D 2F 31 30 38 33   tab 0, row 0, @0x728
2F0 34 33 66 36 5F 4D 75 6C 74 69 43 6F 6C 6F 72 43   tl: 96 fb: --H-FL-- lb: 0x0 cc: 13
300 68 6F 6F 73 65 72 55 49 FF 04 C3 02 58 47 FF 0A   col 0: [ 3] 53 59 53
310 4A 41 56 41 20 43 4C 41 53 53 07 78 66 05 0C 11   col 1: [22]
320 34 3A 07 78 66 05 0C 11 34 3A 13 32 30 30 32 2D   2f 31 30 30 35 62 64 33 30 5f 4c 6e 6b 64 43 6f 6e 73 74 61 6e 74
330 30 35 2D 31 32 3A 31 36 3A 35 31 3A 35 37 05 56   col 2: *NULL*
340 41 4C 49 44 01 4E 01 4E 01 4E 2C73 00 0D 03 53 59   col 3: [ 4] c3 02 49 57
350 53 13 2F 31 30 38 30 34 61 65 37 5F 43 6F 6E 73   col 4: *NULL*
360 74 61 6E 74 73 FF 03 C2 4E 2E FF 0A 4A 41 56 41   col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
370 20 43 4C 41 53 53 07 78 66 05 0C 11 31 04 07 78   col 6: [ 7] 78 66 05 0c 11 34 1a
380 66 05 0C 11 31 04 13 32 30 30 32 2D 30 35 2D 31   col 7: [ 7] 78 66 05 0c 11 34 1a
390 32 3A 31 36 3A 34 38 3A 30 33 05 56 41 4C 49 44   col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 35 31 3a 32 35
3A0 01 4E 01 4E 01 4E 2C74 00 0D 03 53 59 53 1C 2F 31   col 9: [ 5] 56 41 4c 49 44
3B0 30 37 39 63 39 34 64 5F 4E 75 6D 62 65 72 43 6F   col 10: [ 1] 4e
3C0 6E 73 74 61 6E 74 44 61 74 61 FF 04 C3 02 45 57   col 11: [ 1] 4e
3D0 FF 0A 4A 41 56 41 20 43 4C 41 53 53 07 78 66 05   col 12: [ 1] 4e
3E0 0C 11 34 11 07 78 66 05 0C 11 34 11 13 32 30 30   tab 0, row 1, @0x6c1
3F0 32 2D 30 35 2D 31 32 3A 31 36 3A 35 31 3A 31 36   tl: 103 fb: --H-FL-- lb: 0x0 cc: 13
400 05 56 41 4C 49 44 01 4E 01 4E 01 4E 2C75 00 0D 03   col 0: [ 3] 53 59 53
410 53 59 53 1C 2F 31 30 37 34 34 38 33 37 5F 4F 62   col 1: [30]
420 6A 65 63 74 53 74 72 65 61 6D 43 6C 61 73 73 32   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
430 FF 04 C3 02 0D 3D FF 0A 4A 41 56 41 20 43 4C 41   6c 6f 73 75 72
440 53 53 07 78 66 05 0C 11 32 16 07 78 66 05 0C 11   col 2: *NULL*
450 32 16 13 32 30 30 32 2D 30 35 2D 31 32 3A 31 36   col 3: [ 3] c2 4c 3c
460 3A 34 39 3A 32 31 05 56 41 4C 49 44 01 4E 01 4E   col 4: *NULL*
470 01 4E 2C76 00 0D 03 53 59 53 1E 2F 31 30 36 66 61   col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
480 61 62 63 5F 42 61 73 69 63 54 72 65 65 55 49 4B   col 6: [ 7] 78 66 05 0c 11 30 3c
490 65 79 48 61 6E 64 6C 65 FF 03 C2 63 32 FF 0A 4A   col 7: [ 7] 78 66 05 0c 11 30 3c
4A0 41 56 41 20 43 4C 41 53 53 07 78 66 05 0C 11 31   col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 34 37 3a 35 39
4B0 35 07 78 66 05 0C 11 31 35 13 32 30 30 32 2D 30   col 9: [ 5] 56 41 4c 49 44
4C0 35 2D 31 32 3A 31 36 3A 34 38 3A 35 32 05 56 41   col 10: [ 1] 4e
4D0 4C 49 44 01 4E 01 4E 01 4E 2C77 00 0D 03 53 59 53   Rows data col 11: [ 1] 4e
4E0 1A 2F 31 30 36 62 61 30 61 35 5F 41 72 72 61 79   col 12: [ 1] 4e
4F0 45 6E 75 6D 65 72 61 74 69 6F 6E FF 04 C3 03 1C   tab 0, row 2, @0x662
500 62 FF 0A 4A 41 56 41 20 43 4C 41 53 53 07 78 66   tl: 95 fb: --H-FL-- lb: 0x0 cc: 13
510 05 0C 11 39 09 07 78 66 05 0C 12 24 2C 13 32 30   col 0: [ 3] 53 59 53
520 30 32 2D 30 35 2D 31 32 3A 31 37 3A 33 35 3A 32   col 1: [21]
530 31 05 56 41 4C 49 44 01 4E 01 4E 01 4E 2C78 00 0D   2f 31 30 32 39 37 63 39 31 5f 53 41 58 41 74 74 72 4c 69 73 74
540 03 53 59 53 1E 2F 31 30 35 30 37 32 65 37 5F 48   col 2: *NULL*
550 74 74 70 53 65 73 73 69 6F 6E 42 69 6E 64 69 6E   col 3: [ 4] c3 03 1a 2b
560 67 45 76 FF 04 C3 03 1C 30 FF 0A 4A 41 56 41 20   col 4: *NULL*
570 43 4C 41 53 53 07 78 66 05 0C 11 39 03 07 78 66   col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
580 05 0C 12 24 0D 13 32 30 30 32 2D 30 35 2D 31 32   col 6: [ 7] 78 66 05 0c 11 38 28
590 3A 31 37 3A 33 35 3A 30 33 05 56 41 4C 49 44 01   col 7: [ 7] 78 66 05 0c 12 06 22
5A0 4E 01 4E 01 4E 2C79 00 0D 03 53 59 53 1E 2F 31 30   col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 35 35 3a 33 39
5B0 35 30 31 39 30 32 5F 42 61 73 69 63 46 69 6C 65   col 9: [ 5] 56 41 4c 49 44
5C0 43 68 6F 6F 73 65 72 55 49 4E 65 FF 04 C3 02 02   col 10: [ 1] 4e
5D0 4A FF 0A 4A 41 56 41 20 43 4C 41 53 53 07 78 66   col 11: [ 1] 4e
5E0 05 0C 11 31 3C 07 78 66 05 0C 11 31 3C 13 32 30   col 12: [ 1] 4e
5F0 30 32 2D 30 35 2D 31 32 3A 31 36 3A 34 38 3A 35   tab 0, row 3, @0x5fa
600 39 05 56 41 4C 49 44 01 4E 01 4E 01 4E 2C80 00 0D   tl: 104 fb: --H-FL-- lb: 0x0 cc: 13
610 03 53 59 53 17 2F 31 30 34 38 37 33 34 66 5F 44   col 0: [ 3] 53 59 53
620 65 66 61 75 6C 74 46 6F 6C 64 65 72 FF 04 C3 03   col 1: [30]
630 18 2E FF 0A 4A 41 56 41 20 43 4C 41 53 53 07 78   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
640 66 05 0C 11 38 08 07 78 66 05 0C 11 38 18 13 32   74 45 6e 64 50
650 30 30 32 2D 30 35 2D 31 32 3A 31 36 3A 35 35 3A   col 2: *NULL*
660 30 37 05 56 41 4C 49 44 01 4E 01 4E 01 4E 2C81 00   col 3: [ 4] c3 02 25 0f
670 0D 03 53 59 53 1E 2F 31 30 33 61 32 65 37 33 5F   col 4: *NULL*
680 44 65 66 61 75 6C 74 45 64 69 74 6F 72 4B 69 74   col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
690 45 6E 64 50 FF 04 C3 02 25 0F FF 0A 4A 41 56 41   col 6: [ 7] 78 66 05 0c 11 33 0a
6A0 20 43 4C 41 53 53 07 78 66 05 0C 11 33 0A 07 78   col 7: [ 7] 78 66 05 0c 11 33 0a
6B0 66 05 0C 11 33 0A 13 32 30 30 32 2D 30 35 2D 31   col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 35 30 3a 30 39
6C0 32 3A 31 36 3A 35 30 3A 30 39 05 56 41 4C 49 44   col 9: [ 5] 56 41 4c 49 44
6D0 01 4E 01 4E 01 4E 2C82 00 0D 03 53 59 53 15 2F 31   col 10: [ 1] 4e
6E0 30 32 39 37 63 39 31 5F 53 41 58 41 74 74 72 4C   col 11: [ 1] 4e
6F0 69 73 74 FF 04 C3 03 1A 2B FF 0A 4A 41 56 41 20   col 12: [ 1] 4e
700 43 4C 41 53 53 07 78 66 05 0C 11 38 28 07 78 66   tab 0, row 4, @0x599
710 05 0C 12 06 22 13 32 30 30 32 2D 30 35 2D 31 32   tl: 97 fb: --H-FL-- lb: 0x0 cc: 13
720 3A 31 36 3A 35 35 3A 33 39 05 56 41 4C 49 44 01   col 0: [ 3] 53 59 53
730 4E 01 4E 01 4E 2C83 00 0D 03 53 59 53 1E 2F 31 30   col 1: [23]
740 30 37 36 62 32 33 5F 4F 72 61 43 75 73 74 6F 6D   2f 31 30 34 38 37 33 34 66 5f 44 65 66 61 75 6c 74 46 6f 6c 64 65 72
750 44 61 74 75 6D 43 6C 6F 73 75 72 FF 03 C2 4C 3C   col 2: *NULL*
760 FF 0A 4A 41 56 41 20 43 4C 41 53 53 07 78 66 05   col 3: [ 4] c3 03 18 2e
770 0C 11 30 3C 07 78 66 05 0C 11 30 3C 13 32 30 30   col 4: *NULL*
780 32 2D 30 35 2D 31 32 3A 31 36 3A 34 37 3A 35 39   col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
790 05 56 41 4C 49 44 01 4E 01 4E 01 4E 2C84 00 0D 03   col 6: [ 7] 78 66 05 0c 11 38 08
7A0 53 59 53 16 2F 31 30 30 35 62 64 33 30 5F 4C 6E   col 7: [ 7] 78 66 05 0c 11 38 18
7B0 6B 64 43 6F 6E 73 74 61 6E 74 FF 04 C3 02 49 57   col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 35 35 3a 30 37
7C0 FF 0A 4A 41 56 41 20 43 4C 41 53 53 07 78 66 05   col 9: [ 5] 56 41 4c 49 44
7D0 0C 11 34 1A 07 78 66 05 0C 11 34 1A 13 32 30 30   col 10: [ 1] 4e
7E0 32 2D 30 35 2D 31 32 3A 31 36 3A 35 31 3A 32 35   col 11: [ 1] 4e
7F0 05 56 41 4C 49 44 01 4E 01 4E 01 4E 01 06 36 2385   col 12: [ 1] 4e
tab 0, row 5, @0x531
tl: 104 fb: --H-FL-- lb: 0x0 cc: 13
col 0: [ 3] 53 59 53
SQL> select dbms_rowid.rowid_relative_fno(ROWID) as file_ , col 1: [30]
dbms_rowid.rowid_block_number(ROWID) as block_, 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
dbms_rowid.rowid_row_number(ROWID) as row_, t.* from test.heap_table t 72 55 49 4e 65
where object_name='/1095ce9b_MultiComboBoxUI'; col 2: *NULL*
col 3: [ 4] c3 02 02 4a
FILE_ BLOCK_ ROW_ OWNER OBJECT_NAME       SUBOBJECT_NAME   OBJECT_ID col 4: *NULL*
15 34 15 SYS /1095ce9b_MultiComboBoxUI 18772 col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
15 825 10 PUBLIC /1095ce9b_MultiComboBoxUI 18773 col 6: [ 7] 78 66 05 0c 11 31 3c
DATA_OBJECT_ID OBJECT_TYPE   CREATED       LAST_DDL_TIME     TIMESTAMP col 7: [ 7] 78 66 05 0c 11 31 3c
JAVA CLASS 12.05.2002 16:51:57 12.05.2002 16:51:57 2002-05-12:16:51:57 col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 34 38 3a 35 39
SYNONYM 12.05.2002 16:51:57 12.05.2002 16:51:57 2002-05-12:16:51:57 col 9: [ 5] 56 41 4c 49 44
STATUS TEMPORARY GENERATED   col 10: [ 1] 4e
VALID N N col 11: [ 1] 4e
VALID N N col 12: [ 1] 4e
tab 0, row 6, @0x4c9
SQL> alter system dump datafile 15 block 34; tl: 104 fb: --H-FL-- lb: 0x0 cc: 13
SQL> alter system checkpoint; col 0: [ 3] 53 59 53
col 1: [30]
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
69 6e 67 45 76
col 2: *NULL*
col 3: [ 4] c3 03 1c 30
col 4: *NULL*
col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
col 6: [ 7] 78 66 05 0c 11 39 03
col 7: [ 7] 78 66 05 0c 12 24 0d
col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 37 3a 33 35 3a 30 33
col 9: [ 5] 56 41 4c 49 44
col 10: [ 1] 4e
col 11: [ 1] 4e
col 12: [ 1] 4e
tab 0, row 7, @0x465
tl: 100 fb: --H-FL-- lb: 0x0 cc: 13
col 0: [ 3] 53 59 53
col 1: [26]
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
6e
col 2: *NULL*
col 3: [ 4] c3 03 1c 62
col 4: *NULL*
col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
col 6: [ 7] 78 66 05 0c 11 39 09
col 7: [ 7] 78 66 05 0c 12 24 2c
col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 37 3a 33 35 3a 32 31
col 9: [ 5] 56 41 4c 49 44
col 10: [ 1] 4e
col 11: [ 1] 4e
col 12: [ 1] 4e
tab 0, row 8, @0x3fe
tl: 103 fb: --H-FL-- lb: 0x0 cc: 13
col 0: [ 3] 53 59 53
col 1: [30]
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
61 6e 64 6c 65
col 2: *NULL*
col 3: [ 3] c2 63 32
col 4: *NULL*
col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
col 6: [ 7] 78 66 05 0c 11 31 35
col 7: [ 7] 78 66 05 0c 11 31 35
col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 34 38 3a 35 32
col 9: [ 5] 56 41 4c 49 44
col 10: [ 1] 4e
col 11: [ 1] 4e
col 12: [ 1] 4e
tab 0, row 9, @0x398
tl: 102 fb: --H-FL-- lb: 0x0 cc: 13
col 0: [ 3] 53 59 53
col 1: [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
col 2: *NULL*
col 3: [ 4] c3 02 0d 3d
col 4: *NULL*
col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
col 6: [ 7] 78 66 05 0c 11 32 16
col 7: [ 7] 78 66 05 0c 11 32 16
col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 34 39 3a 32 31
col 9: [ 5] 56 41 4c 49 44
col 10: [ 1] 4e
col 11: [ 1] 4e
col 12: [ 1] 4e
tab 0, row 10, @0x332
tl: 102 fb: --H-FL-- lb: 0x0 cc: 13
col 0: [ 3] 53 59 53
col 1: [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
61 74 61
col 2: *NULL*
col 3: [ 4] c3 02 45 57
col 4: *NULL*
col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
col 6: [ 7] 78 66 05 0c 11 34 11
col 7: [ 7] 78 66 05 0c 11 34 11
col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 35 31 3a 31 36
col 9: [ 5] 56 41 4c 49 44
col 10: [ 1] 4e
col 11: [ 1] 4e
col 12: [ 1] 4e
tab 0, row 11, @0x2d6
tl: 92 fb: --H-FL-- lb: 0x0 cc: 13
col 0: [ 3] 53 59 53
col 1: [19] 2f 31 30 38 30 34 61 65 37 5f 43 6f 6e 73 74 61 6e 74 73
col 2: *NULL*
col 3: [ 3] c2 4e 2e
col 4: *NULL*
col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
col 6: [ 7] 78 66 05 0c 11 31 04
col 7: [ 7] 78 66 05 0c 11 31 04
col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 34 38 3a 30 33
col 9: [ 5] 56 41 4c 49 44
col 10: [ 1] 4e
col 11: [ 1] 4e
col 12: [ 1] 4e
tab 0, row 12, @0x26f
tl: 103 fb: --H-FL-- lb: 0x0 cc: 13
col 0: [ 3] 53 59 53
col 1: [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 2: *NULL*
col 3: [ 4] c3 02 58 47
col 4: *NULL*
col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
col 6: [ 7] 78 66 05 0c 11 34 3a
col 7: [ 7] 78 66 05 0c 11 34 3a
col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 35 31 3a 35 37
col 9: [ 5] 56 41 4c 49 44
col 10: [ 1] 4e
col 11: [ 1] 4e
col 12: [ 1] 4e
tab 0, row 13, @0x211
tl: 94 fb: --H-FL-- lb: 0x0 cc: 13
col 0: [ 3] 53 59 53
col 1: [21]
2f 31 30 38 34 35 33 32 30 5f 54 79 70 65 4d 61 70 49 6d 70 6c
col 2: *NULL*
col 3: [ 3] c2 5d 32
col 4: *NULL*
col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
col 6: [ 7] 78 66 05 0c 11 31 27
col 7: [ 7] 78 66 05 0c 11 31 27
col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 34 38 3a 33 38
col 9: [ 5] 56 41 4c 49 44
col 10: [ 1] 4e
col 11: [ 1] 4e
col 12: [ 1] 4e
tab 0, row 14, @0x1b0
tl: 97 fb: --H-FL-- lb: 0x0 cc: 13
col 0: [ 3] 53 59 53
col 1: [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 2: *NULL*
col 3: [ 3] c2 40 48
col 4: *NULL*
col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
col 6: [ 7] 78 66 05 0c 11 30 23
col 7: [ 7] 78 66 05 0c 11 30 23
col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 34 37 3a 33 34
col 9: [ 5] 56 41 4c 49 44
col 10: [ 1] 4e
col 11: [ 1] 4e
col 12: [ 1] 4e
tab 0, row 15, @0x14d
tl: 99 fb: --H-FL-- lb: 0x0 cc: 13
col 0: [ 3] 53 59 53
col 1: [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 2: *NULL*
col 3: [ 4] c3 02 58 49
col 4: *NULL*
col 5: [10] 4a 41 56 41 20 43 4c 41 53 53
col 6: [ 7] 78 66 05 0c 11 34 3a
col 7: [ 7] 78 66 05 0c 11 34 3a
col 8: [19] 32 30 30 32 2d 30 35 2d 31 32 3a 31 36 3a 35 31 3a 35 37
col 9: [ 5] 56 41 4c 49 44
col 10: [ 1] 4e
col 11: [ 1] 4e
col 12: [ 1] 4e
end_of_block_dump

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:0x03C00022
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.00932336
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:0x5B35
10
spare3
11
Flag for data or index block
1 - Data
2 - Index
type:01
12
The object number of the segment in OBJ$.
seg/obj: 0x00007A93 (31379)
13
Cleanout system change,used to show when block cleanout was last performed.
csc: 0x00.932305
14
Count of the ITLs on the block.
itc:3
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: 0x00932305
29
Flag
n=pctfree hit (clusters),
f=don ' t put on freelist,
k=flushable cluster keys
flag:------
30
Number of tables. (>1 so this is a cluster)
ntab:1
31
Number of rows.
nrow:16
32
First free row index entry (-1 - you have to add one)
free: -1
33
Free space begin offset.
fsbo:0032(50)

34
Free space end offset.
fseo:014D (333)
35
Available space in the block.
avsp:283
36
Total available space when all TXs commit.
tosp:283
37
Table offset.
offs:0
38
Rows in table.
nrow :16
39
Begin data row address.
40
offset @0x728 (1832)
41
offset @0x14d (333)
42
Begin free space.
43
table 0, row 15 (offset @0x14d (333))
K - Cluster Key (Flags may change meaning if this is set to show HASH cluster)
C - Cluster table member
H - Head piece of row
D - Deleted row
F - First data piece
L - Last data piece
P - First column continues from previous piece
N - Last column continues in next piece
fb: --H-FL--
( 0010 1100 )
44
Lock byte.
Corresponds with above ITL lck expresses this line whether by lock
lb: 0x0

45
column count
cc: 13

46
len 3
47
"SYS"
48
len 25
49
"/1095ce9b_MultiComboBoxUI"
50
NULL
51
len 4
52
18772
53
NULL
54
len 10
55
"JAVA CLASS"
56
len 7
57
12.05.2002 16:51:57
58
len 7
59
12.05.2002 16:51:57
60
len 19
61
"2002-05-12:16:51:57"
62
len 5
63
"VALID"
64
len 1
65
0
66
len 1
67
0
68
len 1
69
0
70
row =14
71
row =13
72
row =12
73
row =11
74
row =10
75
row =9
76
row =8
77
row =7
78
row =6
79
row =5
80
row =4
81
row =3
82
row =2
83
row =1
84
row =0
85
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:0x23360601