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/6g.html
Title: Table  •  Size: 336290  •  Last Modified: Thu, 04 Feb 2010 15:48:32 GMT
6   TRANS DATA (ASSM table )
 
  0 1 2 3 4 5 6 7 8 9 A B C D E F   Start dump data blocks tsn: 14 file#: 14 minblk 37 maxblk 37
00 061 022 003 004 25 00 80 035 2F C0 60 03 00 006 027 048   buffer tsn: 14 rdba: 0x03800025 (14/37)
10 74 C79 00 0010 0111 00 00 00 4C BF 01 0012 2C C0 60 03   Transaction scn: 0x0000.0360c02f seq: 0x02 flg: 0x04 tail: 0xc02f0602
20 00 0013 00 00 0314 00 3215 0016 21 00 80 0317 FF18 FF19 00 0020    header frmt: 0x02 chkval: 0xc774 type: 0x06=trans data
30 00 00 00 0021 0022 00 00 0023 00 0024 0025 00 00 8026 00 00   Block header dump:  0x03800025
40 2C C0 60 0327 0028 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 0029 00 00 00    seg/obj: 0x1bf4c  csc: 0x00.360c02c  itc: 3  flg: E  typ: 1 - DATA
60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00        brn: 0  bdba: 0x3800021 ver: 0x01
70 00 00 00 00 00 00 00 0030 00 00 00 0031 0032 0133 12 0034        inc: 0  exflg: 0
80 FF FF35 36 0036 04 0137 CE 0038 CE 0039 00 0040 12 0041 2D42 07   Tab.directory  
90 D0 06 73 06 1A 06 C1 05 69 05 11 05 B6 04 61 04   Row directory  Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
A0 0C 04 AA 03 44 03 E5 02 89 02 29 02 C7 01 66 01   0x01   0xffff.000.00000000  0x00000000.0000.00  C---    0  scn 0x0000.0360c02c
B0 04 01 0043 00 00 00 00 00 00 00 00 00 00 00 00 00   0x02   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   0x03   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000
D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   data_block_dump,data header at 0xda8307c
F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   ===============
100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   tsiz: 0x780
110 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   hsiz: 0x36
120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   pbl: 0x0da8307c
130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   bdba: 0x03800025
140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   Free space      76543210
150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   flag=--------
160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   ntab=1
170 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   nrow=18
180 2C44 0045 0D46 0747 43 52 45 41 54 4F 5248 15 41 43 43 4F   frre=-1
190 55 4E 54 45 4E 54 44 45 50 45 4E 44 56 41 4C 55   Rows data fsbo=0x36
1A0 45 FF 04 C3 0A 44 2F 04 C3 0A 44 2F 05 54 41 42   fseo=0x104
1B0 4C 45 07 78 69 07 02 11 2B 05 07 78 69 07 02 14   avsp=0xce
1C0 3B 08 13 32 30 30 35 2D 30 37 2D 30 32 3A 31 36   tosp=0xce
1D0 3A 34 32 3A 30 34 05 56 41 4C 49 44 01 4E 01 4E   0xe:pti[0] nrow=18 offs=0
1E0 01 4E 2C49 00 0D 07 43 52 45 41 54 4F 52 14 41 43   0x12:pri[0] offs=0x72d
1F0 43 4F 55 4E 54 45 4E 54 44 45 50 45 4E 44 45 4E   0x14:pri[1] offs=0x6d0
200 43 59 FF 04 C3 0A 44 2D 04 C3 0A 44 2D 05 54 41   0x16:pri[2] offs=0x673
210 42 4C 45 07 78 69 07 02 11 2B 05 07 78 69 07 02   0x18:pri[3] offs=0x61a
220 12 37 22 13 32 30 30 35 2D 30 37 2D 30 32 3A 31   0x1a:pri[4] offs=0x5c1
230 36 3A 34 32 3A 30 34 05 56 41 4C 49 44 01 4E 01   0x1c:pri[5] offs=0x569
240 4E 01 4E 2C50 00 0D 07 43 52 45 41 54 4F 52 15 41   0x1e:pri[6] offs=0x511
250 43 43 4F 55 4E 54 43 4C 41 53 53 42 59 50 45 52   0x20:pri[7] offs=0x4b6
260 43 45 4E 54 FF 04 C3 0A 44 2B 04 C3 0A 44 2B 05   0x22:pri[8] offs=0x461
270 54 41 42 4C 45 07 78 69 07 02 11 2B 05 07 78 69   0x24:pri[9] offs=0x40c
280 07 02 12 34 24 13 32 30 30 35 2D 30 37 2D 30 32   0x26:pri[10] offs=0x3aa
290 3A 31 36 3A 34 32 3A 30 34 05 56 41 4C 49 44 01   0x28:pri[11] offs=0x344
2A0 4E 01 4E 01 4E 2C51 00 0D 07 43 52 45 41 54 4F 52   0x2a:pri[12] offs=0x2e5
2B0 13 41 43 43 4F 55 4E 54 43 41 54 45 47 4F 52 59   0x2c:pri[13] offs=0x289
2C0 54 59 50 45 FF 04 C3 0A 44 28 04 C3 0A 44 28 05   0x2e:pri[14] offs=0x229
2D0 54 41 42 4C 45 07 78 69 07 02 11 2B 05 07 78 69   0x30:pri[15] offs=0x1c7
2E0 07 02 14 3B 08 13 32 30 30 35 2D 30 37 2D 30 32   0x32:pri[16] offs=0x166
2F0 3A 31 36 3A 34 32 3A 30 34 05 56 41 4C 49 44 01   0x34:pri[17] offs=0x104
300 4E 01 4E 01 4E 2C52 00 0D 07 43 52 45 41 54 4F 52   block_row_dump:
310 0F 41 43 43 4F 55 4E 54 43 41 54 45 47 4F 52 59   tab 0, row 0, @0x72d
320 FF 04 C3 0A 44 25 04 C3 0A 44 25 05 54 41 42 4C   tl: 83 fb: --H-FL-- lb: 0x0  cc: 13
330 45 07 78 69 07 02 11 2B 05 07 78 69 07 02 14 3B   col  0: [ 7]  43 52 45 41 54 4f 52
340 08 13 32 30 30 35 2D 30 37 2D 30 32 3A 31 36 3A   col  1: [ 8]  41 41 43 43 4f 55 4e 54
350 34 32 3A 30 34 05 56 41 4C 49 44 01 4E 01 4E 01   col  2: *NULL*
360 4E 2C53 00 0D 07 43 52 45 41 54 4F 52 12 41 43 43   col  3: [ 3]  c3 0a 44
370 4F 55 4E 54 41 4C 47 52 4F 55 50 4C 49 4E 4B FF   col  4: [ 3]  c3 0a 44
380 04 C3 0A 44 22 04 C3 0A 44 22 05 54 41 42 4C 45   col  5: [ 5]  54 41 42 4c 45
390 07 78 69 07 02 11 2B 05 07 78 69 07 02 14 36 25   col  6: [ 7]  78 69 07 02 11 2a 3a
3A0 13 32 30 30 35 2D 30 37 2D 30 32 3A 31 36 3A 34   col  7: [ 7]  78 69 0c 07 11 37 3c
3B0 32 3A 30 34 05 56 41 4C 49 44 01 4E 01 4E 01 4E   col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 31 3a 35 37
3C0 2C54 00 0D 07 43 52 45 41 54 4F 52 19 41 43 43 4F   col  9: [ 5]  56 41 4c 49 44
3D0 55 4E 54 41 43 43 45 53 53 54 45 4D 50 4C 41 54   col 10: [ 1]  4e
3E0 45 5F 4C 4F 47 FF 04 C3 0A 44 20 04 C3 0A 44 20   col 11: [ 1]  4e
3F0 05 54 41 42 4C 45 07 78 69 07 02 11 2B 04 07 78   col 12: [ 1]  4e
400 69 07 02 12 34 24 13 32 30 30 35 2D 30 37 2D 30   tab 0, row 1, @0x6d0
410 32 3A 31 36 3A 34 32 3A 30 33 05 56 41 4C 49 44   tl: 93 fb: --H-FL-- lb: 0x0  cc: 13
420 01 4E 01 4E 01 4E 2C55 00 0D 07 43 52 45 41 54 4F   col  0: [ 7]  43 52 45 41 54 4f 52
430 52 15 41 43 43 4F 55 4E 54 41 43 43 45 53 53 54   col  1: [16]  41 41 43 43 4f 55 4e 54 53 49 54 45 4c 49 4e 4b
440 45 4D 50 4C 41 54 45 FF 04 C3 0A 44 1D 04 C3 0A   col  2: *NULL*
450 44 1D 05 54 41 42 4C 45 07 78 69 07 02 11 2B 04   col  3: [ 4]  c3 0b 53 15
460 07 78 69 07 02 12 37 22 13 32 30 30 35 2D 30 37   col  4: [ 4]  c3 0b 53 15
470 2D 30 32 3A 31 36 3A 34 32 3A 30 33 05 56 41 4C   col  5: [ 5]  54 41 42 4c 45
480 49 44 01 4E 01 4E 01 4E 2C56 00 0D 07 43 52 45 41   col  6: [ 7]  78 69 07 18 0e 3a 01
490 54 4F 52 0C 41 43 43 4F 55 4E 54 32 53 59 4E 43   col  7: [ 7]  78 69 07 18 0f 21 32
4A0 FF 04 C3 0B 10 08 FF 05 54 41 42 4C 45 07 78 69   col  8: [19]  32 30 30 35 2d 30 37 2d 32 34 3a 31 33 3a 35 37 3a 30 36
4B0 07 02 12 21 2C 07 78 69 07 02 12 37 20 13 32 30   col  9: [ 5]  56 41 4c 49 44
4C0 30 35 2D 30 37 2D 30 32 3A 31 37 3A 33 32 3A 34   col 10: [ 1]  4e
4D0 33 05 56 41 4C 49 44 01 4E 01 4E 01 4E 2C57 00 0D   col 11: [ 1]  4e
4E0 07 43 52 45 41 54 4F 52 08 41 43 43 42 4C 4F 43   col 12: [ 1]  4e
4F0 4B FF 04 C3 0A 44 1A 04 C3 0A 44 1A 05 54 41 42   tab 0, row 2, @0x673
500 4C 45 07 78 69 07 02 11 2B 03 07 78 69 07 18 10   tl: 93 fb: --H-FL-- lb: 0x0  cc: 13
510 36 1F 13 32 30 30 35 2D 30 37 2D 30 32 3A 31 36   col  0: [ 7]  43 52 45 41 54 4f 52
520 3A 34 32 3A 30 33 05 56 41 4C 49 44 01 4E 01 4E   col  1: [16]  41 41 43 43 4f 55 4e 54 54 4f 42 4f 4c 49 4e 4b
530 01 4E 2C58 00 0D 07 43 52 45 41 54 4F 52 0E 41 43   col  2: *NULL*
540 43 34 44 4F 43 46 4F 52 57 41 52 44 FF 04 C3 0A   col  3: [ 4]  c3 0a 44 0b
550 44 18 04 C3 0A 44 18 05 54 41 42 4C 45 07 78 69   col  4: [ 4]  c3 0a 44 0b
560 07 02 11 2B 03 07 78 69 07 02 12 37 22 13 32 30   col  5: [ 5]  54 41 42 4c 45
570 30 35 2D 30 37 2D 30 32 3A 31 36 3A 34 32 3A 30   col  6: [ 7]  78 69 07 02 11 2a 3c
580 32 05 56 41 4C 49 44 01 4E 01 4E 01 4E 2C59 00 0D   col  7: [ 7]  78 69 07 02 14 3b 08
590 07 43 52 45 41 54 4F 52 0B 41 41 43 53 45 53 53   col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 31 3a 35 39
5A0 54 59 50 45 FF 04 C3 0A 44 16 04 C3 0A 44 16 05   col  9: [ 5]  56 41 4c 49 44
5B0 54 41 42 4C 45 07 78 69 07 02 11 2B 03 07 78 69   col 10: [ 1]  4e
5C0 07 02 12 34 24 13 32 30 30 35 2D 30 37 2D 30 32   col 11: [ 1]  4e
5D0 3A 31 36 3A 34 32 3A 30 32 05 56 41 4C 49 44 01   col 12: [ 1]  4e
5E0 4E 01 4E 01 4E 2C60 00 0D 07 43 52 45 41 54 4F 52   tab 0, row 3, @0x61a
5F0 0F 41 41 43 43 4F 55 4E 54 5F 52 45 50 4F 52 54   tl: 89 fb: --H-FL-- lb: 0x0  cc: 13
600 FF 04 C3 0A 44 14 FF 05 54 41 42 4C 45 07 78 69   col  0: [ 7]  43 52 45 41 54 4f 52
610 07 02 11 2B 03 07 78 69 07 02 12 34 23 13 32 30   col  1: [12]  41 41 43 43 4f 55 4e 54 54 59 50 45
620 30 35 2D 30 37 2D 30 32 3A 31 36 3A 34 32 3A 30   col  2: *NULL*
630 32 05 56 41 4C 49 44 01 59 01 4E 01 4E 2C61 00 0D   col  3: [ 4]  c3 0a 44 0e
640 07 43 52 45 41 54 4F 52 0C 41 41 43 43 4F 55 4E   col  4: [ 4]  c3 0a 44 0e
650 54 5F 4C 4F 47 FF 04 C3 0A 44 10 04 C3 0A 44 10   col  5: [ 5]  54 41 42 4c 45
660 05 54 41 42 4C 45 07 78 69 07 02 11 2A 3C 07 78   col  6: [ 7]  78 69 07 02 11 2a 3c
670 69 07 02 14 36 25 13 32 30 30 35 2D 30 37 2D 30   col  7: [ 7]  78 69 07 02 12 34 23
680 32 3A 31 36 3A 34 31 3A 35 39 05 56 41 4C 49 44   col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 31 3a 35 39
690 01 4E 01 4E 01 4E 2C62 00 0D 07 43 52 45 41 54 4F   col  9: [ 5]  56 41 4c 49 44
6A0 52 0C 41 41 43 43 4F 55 4E 54 54 59 50 45 FF 04   col 10: [ 1]  4e
6B0 C3 0A 44 0E 04 C3 0A 44 0E 05 54 41 42 4C 45 07   col 11: [ 1]  4e
6C0 78 69 07 02 11 2A 3C 07 78 69 07 02 12 34 23 13   col 12: [ 1]  4e
6D0 32 30 30 35 2D 30 37 2D 30 32 3A 31 36 3A 34 31   tab 0, row 4, @0x5c1
6E0 3A 35 39 05 56 41 4C 49 44 01 4E 01 4E 01 4E 2C63   tl: 89 fb: --H-FL-- lb: 0x0  cc: 13
6F0 00 0D 07 43 52 45 41 54 4F 52 10 41 41 43 43 4F   col  0: [ 7]  43 52 45 41 54 4f 52
700 55 4E 54 54 4F 42 4F 4C 49 4E 4B FF 04 C3 0A 44   col  1: [12]  41 41 43 43 4f 55 4e 54 5f 4c 4f 47
710 0B 04 C3 0A 44 0B 05 54 41 42 4C 45 07 78 69 07   col  2: *NULL*
720 02 11 2A 3C 07 78 69 07 02 14 3B 08 13 32 30 30   col  3: [ 4]  c3 0a 44 10
730 35 2D 30 37 2D 30 32 3A 31 36 3A 34 31 3A 35 39   col  4: [ 4]  c3 0a 44 10
740 05 56 41 4C 49 44 01 4E 01 4E 01 4E 2C64 00 0D 07   col  5: [ 5]  54 41 42 4c 45
750 43 52 45 41 54 4F 52 10 41 41 43 43 4F 55 4E 54   col  6: [ 7]  78 69 07 02 11 2a 3c
760 53 49 54 45 4C 49 4E 4B FF 04 C3 0B 53 15 04 C3   col  7: [ 7]  78 69 07 02 14 36 25
770 0B 53 15 05 54 41 42 4C 45 07 78 69 07 18 0E 3A   col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 31 3a 35 39
780 01 07 78 69 07 18 0F 21 32 13 32 30 30 35 2D 30   col  9: [ 5]  56 41 4c 49 44
790 37 2D 32 34 3A 31 33 3A 35 37 3A 30 36 05 56 41   col 10: [ 1]  4e
7A0 4C 49 44 01 4E 01 4E 01 4E 2C65 00 0D 07 43 52 45   col 11: [ 1]  4e
7B0 41 54 4F 52 08 41 41 43 43 4F 55 4E 54 FF 03 C3   col 12: [ 1]  4e
7C0 0A 44 03 C3 0A 44 05 54 41 42 4C 45 07 78 69 07   tab 0, row 5, @0x569
7D0 02 11 2A 3A 07 78 69 0C 07 11 37 3C 13 32 30 30   tl: 88 fb: --H-FL-- lb: 0x0  cc: 13
7E0 35 2D 30 37 2D 30 32 3A 31 36 3A 34 31 3A 35 37   col  0: [ 7]  43 52 45 41 54 4f 52
7F0 05 56 41 4C 49 44 01 4E 01 4E 01 4E 02 06 2F C066   col  1: [15]  41 41 43 43 4f 55 4e 54 5f 52 45 50 4f 52 54
col  2: *NULL*
SQL> create  table test_assm  tablespace assm  as  select * from all_objects ; col  3: [ 4]  c3 0a 44 14
col  4: *NULL*
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 11 2b 03
col  7: [ 7]  78 69 07 02 12 34 23
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 32 3a 30 32
col  9: [ 5]  56 41 4c 49 44
col 10: [ 1]  59
col 11: [ 1]  4e
col 12: [ 1]  4e
tab 0, row 6, @0x511
tl: 88 fb: --H-FL-- lb: 0x0  cc: 13
col  0: [ 7]  43 52 45 41 54 4f 52
col  1: [11]  41 41 43 53 45 53 53 54 59 50 45
col  2: *NULL*
col  3: [ 4]  c3 0a 44 16
col  4: [ 4]  c3 0a 44 16
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 11 2b 03
col  7: [ 7]  78 69 07 02 12 34 24
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 32 3a 30 32
col  9: [ 5]  56 41 4c 49 44
col 10: [ 1]  4e
col 11: [ 1]  4e
col 12: [ 1]  4e
tab 0, row 7, @0x4b6
tl: 91 fb: --H-FL-- lb: 0x0  cc: 13
col  0: [ 7]  43 52 45 41 54 4f 52
col  1: [14]  41 43 43 34 44 4f 43 46 4f 52 57 41 52 44
col  2: *NULL*
col  3: [ 4]  c3 0a 44 18
col  4: [ 4]  c3 0a 44 18
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 11 2b 03
col  7: [ 7]  78 69 07 02 12 37 22
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 32 3a 30 32
col  9: [ 5]  56 41 4c 49 44
col 10: [ 1]  4e
col 11: [ 1]  4e
col 12: [ 1]  4e
tab 0, row 8, @0x461
tl: 85 fb: --H-FL-- lb: 0x0  cc: 13
col  0: [ 7]  43 52 45 41 54 4f 52
col  1: [ 8]  41 43 43 42 4c 4f 43 4b
col  2: *NULL*
col  3: [ 4]  c3 0a 44 1a
col  4: [ 4]  c3 0a 44 1a
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 11 2b 03
col  7: [ 7]  78 69 07 18 10 36 1f
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 32 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 9, @0x40c
tl: 85 fb: --H-FL-- lb: 0x0  cc: 13
col  0: [ 7]  43 52 45 41 54 4f 52
col  1: [12]  41 43 43 4f 55 4e 54 32 53 59 4e 43
col  2: *NULL*
col  3: [ 4]  c3 0b 10 08
col  4: *NULL*
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 12 21 2c
col  7: [ 7]  78 69 07 02 12 37 20
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 37 3a 33 32 3a 34 33
col  9: [ 5]  56 41 4c 49 44
col 10: [ 1]  4e
col 11: [ 1]  4e
col 12: [ 1]  4e
tab 0, row 10, @0x3aa
tl: 98 fb: --H-FL-- lb: 0x0  cc: 13
col  0: [ 7]  43 52 45 41 54 4f 52
col  1: [21]
 41 43 43 4f 55 4e 54 41 43 43 45 53 53 54 45 4d 50 4c 41 54 45
col  2: *NULL*
col  3: [ 4]  c3 0a 44 1d
col  4: [ 4]  c3 0a 44 1d
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 11 2b 04
col  7: [ 7]  78 69 07 02 12 37 22
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 32 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 11, @0x344
tl: 102 fb: --H-FL-- lb: 0x0  cc: 13
col  0: [ 7]  43 52 45 41 54 4f 52
col  1: [25]
 41 43 43 4f 55 4e 54 41 43 43 45 53 53 54 45 4d 50 4c 41 54 45 5f 4c 4f 47
col  2: *NULL*
col  3: [ 4]  c3 0a 44 20
col  4: [ 4]  c3 0a 44 20
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 11 2b 04
col  7: [ 7]  78 69 07 02 12 34 24
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 32 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, @0x2e5
tl: 95 fb: --H-FL-- lb: 0x0  cc: 13
col  0: [ 7]  43 52 45 41 54 4f 52
col  1: [18]  41 43 43 4f 55 4e 54 41 4c 47 52 4f 55 50 4c 49 4e 4b
col  2: *NULL*
col  3: [ 4]  c3 0a 44 22
col  4: [ 4]  c3 0a 44 22
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 11 2b 05
col  7: [ 7]  78 69 07 02 14 36 25
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 32 3a 30 34
col  9: [ 5]  56 41 4c 49 44
col 10: [ 1]  4e
col 11: [ 1]  4e
col 12: [ 1]  4e
tab 0, row 13, @0x289
tl: 92 fb: --H-FL-- lb: 0x0  cc: 13
col  0: [ 7]  43 52 45 41 54 4f 52
col  1: [15]  41 43 43 4f 55 4e 54 43 41 54 45 47 4f 52 59
col  2: *NULL*
col  3: [ 4]  c3 0a 44 25
col  4: [ 4]  c3 0a 44 25
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 11 2b 05
col  7: [ 7]  78 69 07 02 14 3b 08
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 32 3a 30 34
col  9: [ 5]  56 41 4c 49 44
col 10: [ 1]  4e
col 11: [ 1]  4e
col 12: [ 1]  4e
tab 0, row 14, @0x229
tl: 96 fb: --H-FL-- lb: 0x0  cc: 13
col  0: [ 7]  43 52 45 41 54 4f 52
col  1: [19]  41 43 43 4f 55 4e 54 43 41 54 45 47 4f 52 59 54 59 50 45
col  2: *NULL*
col  3: [ 4]  c3 0a 44 28
col  4: [ 4]  c3 0a 44 28
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 11 2b 05
col  7: [ 7]  78 69 07 02 14 3b 08
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 32 3a 30 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, @0x1c7
tl: 98 fb: --H-FL-- lb: 0x0  cc: 13
col  0: [ 7]  43 52 45 41 54 4f 52
col  1: [21]
 41 43 43 4f 55 4e 54 43 4c 41 53 53 42 59 50 45 52 43 45 4e 54
col  2: *NULL*
col  3: [ 4]  c3 0a 44 2b
col  4: [ 4]  c3 0a 44 2b
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 11 2b 05
col  7: [ 7]  78 69 07 02 12 34 24
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 32 3a 30 34
col  9: [ 5]  56 41 4c 49 44
col 10: [ 1]  4e
col 11: [ 1]  4e
col 12: [ 1]  4e
tab 0, row 16, @0x166
tl: 97 fb: --H-FL-- lb: 0x0  cc: 13
col  0: [ 7]  43 52 45 41 54 4f 52
col  1: [20]  41 43 43 4f 55 4e 54 45 4e 54 44 45 50 45 4e 44 45 4e 43 59
col  2: *NULL*
col  3: [ 4]  c3 0a 44 2d
col  4: [ 4]  c3 0a 44 2d
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 11 2b 05
col  7: [ 7]  78 69 07 02 12 37 22
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 32 3a 30 34
col  9: [ 5]  56 41 4c 49 44
col 10: [ 1]  4e
col 11: [ 1]  4e
col 12: [ 1]  4e
tab 0, row 17, @0x104
tl: 98 fb: --H-FL-- lb: 0x0  cc: 13
col  0: [ 7]  43 52 45 41 54 4f 52
col  1: [21]
 41 43 43 4f 55 4e 54 45 4e 54 44 45 50 45 4e 44 56 41 4c 55 45
col  2: *NULL*
col  3: [ 4]  c3 0a 44 2f
col  4: [ 4]  c3 0a 44 2f
col  5: [ 5]  54 41 42 4c 45
col  6: [ 7]  78 69 07 02 11 2b 05
col  7: [ 7]  78 69 07 02 14 3b 08
col  8: [19]  32 30 30 35 2d 30 37 2d 30 32 3a 31 36 3a 34 32 3a 30 34
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:0x03800025
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.0360C02F
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:0x02
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:0xC774
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:0x0001BF4C
13
Cleanout system change,used to show when block cleanout was last performed. csc: 0x0000.0360C02C
14
Count of the ITLs on the block.
itc:3
15
Flag : '-' means that the block is not on the freelist,'O' - in freelist, 'E' - ASSM.
flg:32 (0) - ASSM
16
(ASSM) DBA range number opcode.
brn:0
17
(ASSM) L1 BMB address.
bdba: 0x03800021
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.
19
Rollback segment
20
Refers to a slot in the transaction table.
21
Refers to the number of times that the slot has been used (i.e. incarnation or version) in a transaction.
22
The UBA is the pointer to the tail of the undo chain for the block. UBA:(undodatablockaddr.sequence#.record#)
23
DBA of the rollback segment block.
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--- = transaction has been committed and locks cleaned out.
Lck: The number of row-level locks held in the block by this transaction.
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).
(SCN of commited TX )Scn: 0x0000.0360C02C
28
ITL slot ¹ 2
29
ITL slot ¹ 3
30
(ASSM) Incarnation of block (if HWM is pulled back). inc:0
31
(ASSM) exflg:0
32
Flag  n=pctfree hit (clusters); f = don ' t put on freelist; k=flushable cluster keys.
flag:------
33
Number of tables. (>1 so this is a cluster).
ntab:1
34
Number of rows.
nrow:18
35
free: first free row index entry -1 - you have to add one
36
Free space begin offset. fsbo:0036
37
Free space end offset. fseo:0104
38
Available space in the block. avsp:206
39
Total available space when all TXs commit. tosp:206
40
Table offset. offs:0
41
Rows in table. nrow :18
42
Begin data row address...
43
Begin free space
44
table  0,  row   17 (offset @0x104)
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 )
45
Lock byte.
Corresponds with above ITL lck expresses this line whether by lock
lb: 0x0
46
column count
cc: 13
47
len 7
48
data
49
Row ¹ 16
50
Row ¹ 15
51
Row ¹ 14
52
Row ¹ 13
53
Row ¹ 12
54
Row ¹ 11
55
Row ¹ 10
56
Row ¹ 9
57
Row ¹ 8
58
Row ¹ 7
59
Row ¹ 6
60
Row ¹ 5
61
Row ¹ 4
62
Row ¹ 3
63
Row ¹ 2
64
Row ¹ 1
65
Row ¹ 0
66
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:0xC02F0602