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/6b.html
Title: 6.Trans data-IOT  •  Size: 594586  •  Last Modified: Thu, 04 Feb 2010 15:48:32 GMT
6 TRANS DATA (IOT\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 43 maxblk 43
00 061 022 003 004 2B 00 C0 035 72 A2 94 00 00 006 017 068   buffer tsn: 16 rdba: 0x03c0002b (15/43)
10 D4 A99 00 0010 0211 00 00 00 BB 7A 00 0012 52 A2 94 00   Transaction scn: 0x0000.0094a272 seq: 0x01 flg: 0x06 tail: 0xa2720601
20 00 0013 00 00 0214 00 0215 0016 00 00 00 0017 0A18 0019 12 0020   header frmt: 0x02 chkval: 0xa9d4 type: 0x06=trans data
30 D5 1F 00 0021 3422 00 80 0023 13 0424 0525 00 01 6026 00 0027   ITL Block header dump: 0x03c0002b
40 54 A2 94 0028 0A 00 10 00 D5 1F 00 00 35 00 80 00   Object id on Block? Y
50 13 04 0E 00 15 20 00 00 72 A2 94 00 0029 0130 9031 0132   Common seg/obj: 0x7abb csc: 0x00.94a252 itc: 2 flg: - typ: 2 - INDEX
60 02 00 00 0033 15 0034 4E 0035 62 0036 14 0037 00 0038 00 0039   Index Header fsl: 0 fnx: 0x0 ver: 0x01
70 2C 00 C0 0340 4B 00 C0 0341 00 0042 00 00 64 0743 00 00   Leaf header
80 6244 0045 B2 00 07 01 56 01 A6 01 F9 01 5C 02 A7 02   Itl Xid Uba Flag Lck Scn/Fsc
90 F6 02 4C 03 AF 03 11 04 64 04 B0 04 06 05 5B 05   Row directory 0x01 0x000a.012.00001fd5 0x00800034.0413.05 -BU- 1 fsc 0x0000.0094a254
A0 AC 05 F8 05 54 06 AD 06 09 07 2346 07 06 05 42 07   Free space 0x02 0x000a.010.00001fd5 0x00800035.0413.0e --U- 21 fsc 0x0000.0094a272
B0 25 05 DF 04 23 07 06 05 42 07 25 05 00 00 0647 0248  
C0 0949 41 52 47 55 4D 45 4E 54 2450 2C51 0052 0C53 0354 53 59   Leaf block dump
D0 5355 FF56 0257 C1 4758 0259 C1 4760 0561 54 41 42 4C 4562 0763 78   ===============
E0 66 05 0C 11 13 0564 0765 78 66 05 0C 12 1E 3866 13 32   Row data header address 66072668=0x3f0305c
F0 30 30 32 2D 30 35 2D 31 32 3A 31 36 3A 31 38 3A   kdxcolev 0
100 30 3467 0568 56 41 4C 49 4469 0170 4E71 0172 4E73 0174 4E75 0676 02   KDXCOLEV Flags = - - -
110 0C 41 53 53 4F 43 49 41 54 49 4F 4E 24 2C 00 0C   kdxcolok 1
120 03 53 59 53 FF 03 C2 04 51 03 C2 04 51 05 54 41   kdxcoopc 0x90: opcode=0: iot flags=I-- is converted=Y
130 42 4C 45 07 78 66 05 0C 11 13 17 07 78 66 05 0C   kdxconco 1
140 11 13 17 13 32 30 30 32 2D 30 35 2D 31 32 3A 31   kdxcosdc 2
150 36 3A 31 38 3A 32 32 05 56 41 4C 49 44 01 4E 01   kdxconro 21
160 4E 01 4E 0677 02 09 41 54 45 4D 50 54 41 42 24 2C   kdxcofbo 78=0x4e
170 00 0C 03 53 59 53 FF 03 C2 04 3A FF 05 54 41 42   kdxcofeo 98=0x62
180 4C 45 07 78 66 05 0C 11 13 16 07 78 66 05 0C 11   kdxcoavs 20
190 13 16 13 32 30 30 32 2D 30 35 2D 31 32 3A 31 36   kdxlespl 0
1A0 3A 31 38 3A 32 31 05 56 41 4C 49 44 01 59 01 4E   kdxlende 0
1B0 01 4E 0678 02 08 41 54 54 52 43 4F 4C 24 2C 00 0C   kdxlenxt 62914604=0x3c0002c
1C0 03 53 59 53 FF 03 C2 03 59 02 C1 03 05 54 41 42   kdxleprv 62914635=0x3c0004b
1D0 4C 45 07 78 66 05 0C 11 13 13 07 78 66 05 0C 11   kdxledsz 0
1E0 13 13 13 32 30 30 32 2D 30 35 2D 31 32 3A 31 36   kdxlebksz 1892
1F0 3A 31 38 3A 31 38 05 56 41 4C 49 44 01 4E 01 4E   row#0[98] flag: K---S, lock: 2
200 01 4E 0679 02 0A 41 54 54 52 49 42 55 54 45 24 2C   col 0; len 9; (9): 41 52 47 55 4d 45 4e 54 24
210 00 0C 03 53 59 53 FF 03 C2 04 07 03 C2 03 61 05   tl: 68 fb: --H-FL-- lb: 0x0 cc: 12
220 54 41 42 4C 45 07 78 66 05 0C 11 13 13 07 78 66   col 0: [ 3]
230 05 0C 11 13 14 13 32 30 30 32 2D 30 35 2D 31 32   Dump of memory from 0x03F030CE to 0x03F030D1
240 3A 31 36 3A 31 38 3A 31 38 05 56 41 4C 49 44 01   3F030C0 5953030C [..SY]
250 4E 01 4E 01 4E 0680 02 1A 41 54 54 52 49 42 55 54   3F030D0 C102FF53 [S...]
260 45 5F 54 52 41 4E 53 46 4F 52 4D 41 54 49 4F 4E   col 1: *NULL*
270 53 24 2C 00 0C 03 53 59 53 FF 03 C2 23 4E 03 C2   col 2: [ 2]
280 23 4E 05 54 41 42 4C 45 07 78 66 05 0C 11 1B 12   Dump of memory from 0x03F030D3 to 0x03F030D5
290 07 78 66 05 0C 11 1B 12 13 32 30 30 32 2D 30 35   3F030D0 C102FF53 47C10247 [S...G..G]
2A0 2D 31 32 3A 31 36 3A 32 36 3A 31 37 05 56 41 4C   col 3: [ 2]
2B0 49 44 01 4E 01 4E 01 4E 0681 02 04 41 55 44 24 2C   Dump of memory from 0x03F030D6 to 0x03F030D8
2C0 00 0C 03 53 59 53 FF 02 C1 63 02 C1 63 05 54 41   3F030D0 47C10247 [G..G]
2D0 42 4C 45 07 78 66 05 0C 11 13 07 07 78 66 05 0C   col 4: [ 5]
2E0 11 13 12 13 32 30 30 32 2D 30 35 2D 31 32 3A 31   Dump of memory from 0x03F030D9 to 0x03F030DE
2F0 36 3A 31 38 3A 30 36 05 56 41 4C 49 44 01 4E 01   3F030D0 42415405 7807454C [.TABLE.x]
300 4E 01 4E 0682 02 06 41 55 44 49 54 24 2C 00 0C 03   col 5: [ 7]
310 53 59 53 FF 03 C2 02 33 03 C2 02 33 05 54 41 42   Dump of memory from 0x03F030DF to 0x03F030E6
320 4C 45 07 78 66 05 0C 11 13 09 07 78 66 05 0C 11   3F030D0 7807454C [LE.x]
330 13 09 13 32 30 30 32 2D 30 35 2D 31 32 3A 31 36   3F030E0 110C0566 78070513 [f......x]
340 3A 31 38 3A 30 38 05 56 41 4C 49 44 01 4E 01 4E   col 6: [ 7]
350 01 4E 0683 02 0D 41 55 44 49 54 5F 41 43 54 49 4F   Dump of memory from 0x03F030E7 to 0x03F030EE
360 4E 53 2C 00 0C 03 53 59 53 FF 03 C2 16 2F 03 C2   3F030E0 78070513 120C0566 3213381E [...xf....8.2]
370 16 2F 05 54 41 42 4C 45 07 78 66 05 0C 11 16 30   col 7: [19]
380 07 78 66 05 0C 11 16 31 13 32 30 30 32 2D 30 35   Dump of memory from 0x03F030EF to 0x03F03102
390 2D 31 32 3A 31 36 3A 32 31 3A 34 37 05 56 41 4C   3F030E0 3213381E [.8.2]
3A0 49 44 01 4E 01 4E 01 4E 0684 02 18 41 55 52 4F 52   3F030F0 2D323030 312D3530 36313A32 3A38313A [002-05-12:16:18:]
3B0 41 24 53 48 55 54 44 4F 57 4E 24 43 4C 41 53 53   3F03100 56053430 [04.V]
3C0 45 53 24 2C 00 0C 03 53 59 53 FF 04 C3 03 15 32   col 8: [ 5]
3D0 04 C3 03 15 32 05 54 41 42 4C 45 07 78 66 05 0C   Dump of memory from 0x03F03103 to 0x03F03108
3E0 11 37 2C 07 78 66 05 0C 11 37 2C 13 32 30 30 32   3F03100 56053430 44494C41 [04.VALID]
3F0 2D 30 35 2D 31 32 3A 31 36 3A 35 34 3A 34 33 05   col 9: [ 1]
400 56 41 4C 49 44 01 4E 01 4E 01 4E 0685 02 17 41 55   Dump of memory from 0x03F03109 to 0x03F0310A
410 52 4F 52 41 24 53 54 41 52 54 55 50 24 43 4C 41   3F03100 4E014E01 [.N.N]
420 53 53 45 53 24 2C 00 0C 03 53 59 53 FF 04 C3 03   col 10: [ 1]
430 15 31 04 C3 03 15 31 05 54 41 42 4C 45 07 78 66   Dump of memory from 0x03F0310B to 0x03F0310C
440 05 0C 11 37 2C 07 78 66 05 0C 11 37 2C 13 32 30   3F03100 4E014E01 [.N.N]
450 30 32 2D 30 35 2D 31 32 3A 31 36 3A 35 34 3A 34   col 11: [ 1]
460 33 05 56 41 4C 49 44 01 4E 01 4E 01 4E 0686 02 0A   Dump of memory from 0x03F0310D to 0x03F0310E
470 41 55 58 5F 53 54 41 54 53 24 2C 00 0C 03 53 59   3F03100 02064E01 [.N..]
480 53 FF 03 C2 06 0D 03 C2 06 0D 05 54 41 42 4C 45   row#1[178] flag: K---S, lock: 2
490 07 78 66 05 0C 11 13 38 07 78 66 05 0C 11 19 36   col 0; len 12; (12): 41 53 53 4f 43 49 41 54 49 4f 4e 24
4A0 13 32 30 30 32 2D 30 35 2D 31 32 3A 31 36 3A 31   tl: 70 fb: --H-FL-- lb: 0x0 cc: 12
4B0 38 3A 35 35 05 56 41 4C 49 44 01 4E 01 4E 01 4E   col 0: [ 3]
4C0 0687 02 03 41 57 24 2C 00 0C 03 53 59 53 FF 03 C2   Dump of memory from 0x03F03121 to 0x03F03124
4D0 06 12 03 C2 06 12 05 54 41 42 4C 45 07 78 66 05   3F03120 53595303 [.SYS]
4E0 0C 11 13 38 07 78 66 05 0C 12 3C 0D 13 32 30 30   col 1: *NULL*
4F0 32 2D 30 35 2D 31 32 3A 31 36 3A 31 38 3A 35 35   col 2: [ 3]
500 05 56 41 4C 49 44 01 4E 01 4E 01 4E 0688 02 0B 41   Dump of memory from 0x03F03126 to 0x03F03129
510 57 24 43 57 4D 54 4F 45 43 4D 2C 00 0C 03 53 59   3F03120 04C203FF 04C20351 [....Q...]
520 53 FF 04 C3 03 56 4E 04 C3 03 56 4E 05 54 41 42   col 3: [ 3]
530 4C 45 07 78 66 05 0C 12 3A 38 07 78 66 05 0C 12   Dump of memory from 0x03F0312A to 0x03F0312D
540 3B 1D 13 32 30 30 32 2D 30 35 2D 31 32 3A 31 37   3F03120 04C20351 41540551 [Q...Q.TA]
550 3A 35 37 3A 35 35 05 56 41 4C 49 44 01 4E 01 4E   col 4: [ 5]
560 01 4E 0689 02 0A 41 57 24 45 58 50 52 45 53 53 2C   Dump of memory from 0x03F0312E to 0x03F03133
570 00 0C 03 53 59 53 FF 04 C3 03 56 4A 04 C3 03 56   3F03120 41540551 [Q.TA]
580 4A 05 54 41 42 4C 45 07 78 66 05 0C 12 3A 1B 07   3F03130 07454C42 [BLE.]
590 78 66 05 0C 12 3A 38 13 32 30 30 32 2D 30 35 2D   col 5: [ 7]
5A0 31 32 3A 31 37 3A 35 37 3A 32 36 05 56 41 4C 49   Dump of memory from 0x03F03134 to 0x03F0313B
5B0 44 01 4E 01 4E 01 4E 0690 02 0A 42 4F 4F 54 53 54   3F03130 0C056678 07171311 [xf......]
5C0 52 41 50 24 2C 00 0C 03 53 59 53 FF 02 C1 39 02   col 6: [ 7]
5D0 C1 39 05 54 41 42 4C 45 07 78 66 05 0C 11 13 01   Dump of memory from 0x03F0313C to 0x03F03143
5E0 07 78 66 05 0C 11 13 01 13 32 30 30 32 2D 30 35   3F03130 0C056678 [xf..]
5F0 2D 31 32 3A 31 36 3A 31 38 3A 30 30 05 56 41 4C   3F03140 13171311 [....]
600 49 44 01 4E 01 4E 01 4E 0691 02 05 43 43 4F 4C 24   col 7: [19]
610 2C 00 0C 03 53 59 53 FF 02 C1 21 02 C1 1E 05 54   Dump of memory from 0x03F03144 to 0x03F03157
620 41 42 4C 45 07 78 66 05 0C 11 13 01 07 78 66 05   3F03140 32303032 2D35302D 313A3231 [2002-05-12:1]
630 0C 12 3C 0B 13 32 30 30 32 2D 30 35 2D 31 32 3A   3F03150 38313A36 0532323A [6:18:22.]
640 31 36 3A 31 38 3A 30 30 05 56 41 4C 49 44 01 4E   col 8: [ 5]
650 01 4E 01 4E 0692 02 13 43 44 43 5F 43 48 41 4E 47   Dump of memory from 0x03F03158 to 0x03F0315D
660 45 5F 43 4F 4C 55 4D 4E 53 24 2C 00 0C 03 53 59   3F03150 494C4156 014E0144 [VALID.N.]
670 53 FF 03 C2 05 5A 03 C2 05 5A 05 54 41 42 4C 45   col 9: [ 1]
680 07 78 66 05 0C 11 13 36 07 78 66 05 0C 11 13 36   Dump of memory from 0x03F0315E to 0x03F0315F
690 13 32 30 30 32 2D 30 35 2D 31 32 3A 31 36 3A 31   3F03150 014E0144 [D.N.]
6A0 38 3A 35 33 05 56 41 4C 49 44 01 4E 01 4E 01 4E   col 10: [ 1]
6B0 0693 02 10 43 44 43 5F 43 48 41 4E 47 45 5F 53 45   Dump of memory from 0x03F03160 to 0x03F03161
6C0 54 53 24 2C 00 0C 03 53 59 53 FF 03 C2 05 4F 03   3F03160 064E014E [N.N.]
6D0 C2 05 4F 05 54 41 42 4C 45 07 78 66 05 0C 11 13   col 11: [ 1]
6E0 35 07 78 66 05 0C 11 13 35 13 32 30 30 32 2D 30   Dump of memory from 0x03F03162 to 0x03F03163
6F0 35 2D 31 32 3A 31 36 3A 31 38 3A 35 32 05 56 41   3F03160 064E014E [N.N.]
700 4C 49 44 01 4E 01 4E 01 4E 0694 02 13 43 44 43 5F   row#2[263] flag: K---S, lock: 2
710 43 48 41 4E 47 45 5F 53 4F 55 52 43 45 53 24 2C   col 0; len 9; (9): 41 54 45 4d 50 54 41 42 24
720 00 0C 03 53 59 53 FF 03 C2 05 4D 03 C2 05 4D 05   tl: 67 fb: --H-FL-- lb: 0x0 cc: 12
730 54 41 42 4C 45 07 78 66 05 0C 11 13 35 07 78 66   col 0: [ 3]
740 05 0C 11 13 35 13 32 30 30 32 2D 30 35 2D 31 32   Dump of memory from 0x03F03173 to 0x03F03176
750 3A 31 36 3A 31 38 3A 35 32 05 56 41 4C 49 44 01   3F03170 53030C00 03FF5359 [...SYS..]
760 4E 01 4E 01 4E 0695 02 12 43 44 43 5F 43 48 41 4E   col 1: *NULL*
770 47 45 5F 54 41 42 4C 45 53 24 2C 00 0C 03 53 59   col 2: [ 3]
780 53 FF 03 C2 05 51 03 C2 05 51 05 54 41 42 4C 45   Dump of memory from 0x03F03178 to 0x03F0317B
790 07 78 66 05 0C 11 13 35 07 78 66 05 0C 11 13 36   3F03170 FF3A04C2 [..:.]
7A0 13 32 30 30 32 2D 30 35 2D 31 32 3A 31 36 3A 31   col 3: *NULL*
7B0 38 3A 35 32 05 56 41 4C 49 44 01 4E 01 4E 01 4E   col 4: [ 5]
7C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   Dump of memory from 0x03F0317D to 0x03F03182
7D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   3F03170 42415405 [.TAB]
7E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   3F03180 7807454C [LE.x]
7F0 00 00 00 00 00 00 00 00 00 00 00 00 01 06 72 A296   col 5: [ 7]
Dump of memory from 0x03F03183 to 0x03F0318A
SQL> create table test.IOT_table 3F03180 7807454C 110C0566 78071613 [LE.xf......x]
( col 6: [ 7]
OWNER VARCHAR2(30), Dump of memory from 0x03F0318B to 0x03F03192
OBJECT_NAME VARCHAR2(30) not null, 3F03180 78071613 110C0566 [...xf...]
SUBOBJECT_NAME VARCHAR2(30), 3F03190 32131613 [...2]
OBJECT_ID NUMBER, col 7: [19]
DATA_OBJECT_ID NUMBER, Dump of memory from 0x03F03193 to 0x03F031A6
OBJECT_TYPE VARCHAR2(18), 3F03190 32131613 2D323030 312D3530 36313A32 [...2002-05-12:16]
CREATED DATE, 3F031A0 3A38313A 56053132 [:18:21.V]
LAST_DDL_TIME DATE, col 8: [ 5]
TIMESTAMP VARCHAR2(19), Dump of memory from 0x03F031A7 to 0x03F031AC
STATUS VARCHAR2(7), 3F031A0 56053132 44494C41 [21.VALID]
TEMPORARY VARCHAR2(1), col 9: [ 1]
GENERATED VARCHAR2(1), Dump of memory from 0x03F031AD to 0x03F031AE
SECONDARY VARCHAR2(1), 3F031A0 4E015901 [.Y.N]
PRIMARY KEY (OBJECT_NAME) col 10: [ 1]
) Dump of memory from 0x03F031AF to 0x03F031B0
organization index; 3F031A0 4E015901 [.Y.N]
col 11: [ 1]
SQL>insert into test.IOT_table select * from all_objects Dump of memory from 0x03F031B1 to 0x03F031B2
where owner='SYS' and object_type='TABLE' order by object_name ; 3F031B0 02064E01 [.N..]
SQL>commit; row#3[342] flag: K---S, lock: 2
col 0; len 8; (8): 41 54 54 52 43 4f 4c 24
SQL>select object_id from all_objects tl: 69 fb: --H-FL-- lb: 0x0 cc: 12
where object_name='IOT_TABLE' and owner='TEST'; col 0: [ 3]
Dump of memory from 0x03F031C1 to 0x03F031C4
OBJECT_ID   3F031C0 53595303 [.SYS]
31418 col 1: *NULL*
col 2: [ 3]
SQL>select dataobj# from obj$ where name='SYS_IOT_TOP_31418'; Dump of memory from 0x03F031C6 to 0x03F031C9
3F031C0 03C203FF 03C10259 [....Y...]
DATAOBJ#   col 3: [ 2]
31419 Dump of memory from 0x03F031CA to 0x03F031CC
3F031C0 03C10259 [Y...]
SQL>alter session set events 'immediate trace name treedump level 31419'; col 4: [ 5]
Dump of memory from 0x03F031CD to 0x03F031D2
alter session set events 'immediate trace name treedump level 31419'   3F031C0 42415405 [.TAB]
3F031D0 7807454C [LE.x]
----- begin tree dump col 5: [ 7]
branch: 0x3c0002a 62914602 (0: nrow: 33, level: 1) Dump of memory from 0x03F031D3 to 0x03F031DA
leaf: 0x3c0003b 62914619 (-1: nrow: 0 rrow: 0) 3F031D0 7807454C 110C0566 78071313 [LE.xf......x]
leaf: 0x3c0003c 62914620 (0: nrow: 0 rrow: 0) col 6: [ 7]
leaf: 0x3c0003d 62914621 (1: nrow: 0 rrow: 0) Dump of memory from 0x03F031DB to 0x03F031E2
leaf: 0x3c0003e 62914622 (2: nrow: 0 rrow: 0) 3F031D0 78071313 110C0566 [...xf...]
leaf: 0x3c0003f 62914623 (3: nrow: 0 rrow: 0) 3F031E0 32131313 [...2]
leaf: 0x3c00040 62914624 (4: nrow: 0 rrow: 0) col 7: [19]
leaf: 0x3c00041 62914625 (5: nrow: 0 rrow: 0) Dump of memory from 0x03F031E3 to 0x03F031F6
leaf: 0x3c00042 62914626 (6: nrow: 0 rrow: 0) 3F031E0 32131313 2D323030 312D3530 36313A32 [...2002-05-12:16]
leaf: 0x3c00043 62914627 (7: nrow: 0 rrow: 0) 3F031F0 3A38313A 56053831 [:18:18.V]
leaf: 0x3c00044 62914628 (8: nrow: 0 rrow: 0) col 8: [ 5]
leaf: 0x3c00045 62914629 (9: nrow: 0 rrow: 0) Dump of memory from 0x03F031F7 to 0x03F031FC
leaf: 0x3c00046 62914630 (10: nrow: 0 rrow: 0) 3F031F0 56053831 44494C41 [18.VALID]
leaf: 0x3c00047 62914631 (11: nrow: 0 rrow: 0) col 9: [ 1]
leaf: 0x3c00048 62914632 (12: nrow: 0 rrow: 0) Dump of memory from 0x03F031FD to 0x03F031FE
leaf: 0x3c00049 62914633 (13: nrow: 0 rrow: 0) 3F031F0 4E014E01 [.N.N]
leaf: 0x3c0004a 62914634 (14: nrow: 0 rrow: 0) col 10: [ 1]
leaf: 0x3c0004b 62914635 (15: nrow: 20 rrow: 20) Dump of memory from 0x03F031FF to 0x03F03200
leaf: 0x3c0002b 62914603 (16: nrow: 21 rrow: 21) 3F031F0 4E014E01 [.N.N]
leaf: 0x3c0002c 62914604 (17: nrow: 21 rrow: 21) col 11: [ 1]
leaf: 0x3c0002d 62914605 (18: nrow: 22 rrow: 22) Dump of memory from 0x03F03201 to 0x03F03202
leaf: 0x3c0002e 62914606 (19: nrow: 21 rrow: 21) 3F03200 02064E01 [.N..]
leaf: 0x3c0002f 62914607 (20: nrow: 21 rrow: 21) row#4[422] flag: K---S, lock: 2
leaf: 0x3c00030 62914608 (21: nrow: 21 rrow: 21) col 0; len 10; (10): 41 54 54 52 49 42 55 54 45 24
leaf: 0x3c00031 62914609 (22: nrow: 20 rrow: 20) tl: 70 fb: --H-FL-- lb: 0x0 cc: 12
leaf: 0x3c00032 62914610 (23: nrow: 21 rrow: 21) col 0: [ 3]
leaf: 0x3c00033 62914611 (24: nrow: 21 rrow: 21) Dump of memory from 0x03F03213 to 0x03F03216
leaf: 0x3c00034 62914612 (25: nrow: 21 rrow: 21) 3F03210 53030C00 03FF5359 [...SYS..]
leaf: 0x3c00035 62914613 (26: nrow: 21 rrow: 21) col 1: *NULL*
leaf: 0x3c00036 62914614 (27: nrow: 22 rrow: 22) col 2: [ 3]
leaf: 0x3c00037 62914615 (28: nrow: 20 rrow: 20) Dump of memory from 0x03F03218 to 0x03F0321B
leaf: 0x3c00038 62914616 (29: nrow: 21 rrow: 21) 3F03210 030704C2 [....]
leaf: 0x3c00039 62914617 (30: nrow: 22 rrow: 22) col 3: [ 3]
leaf: 0x3c0003a 62914618 (31: nrow: 21 rrow: 21) Dump of memory from 0x03F0321C to 0x03F0321F
----- end tree dump 3F03210 056103C2 [..a.]
SQL>select dbms_utility.data_block_address_file( 62914603)as file_, col 4: [ 5]
dbms_utility.data_block_address_block( 62914603) as block_ from dual; Dump of memory from 0x03F03220 to 0x03F03225
3F03220 4C424154 66780745 [TABLE.xf]
FILE_       BLOCK_     col 5: [ 7]
15 43 Dump of memory from 0x03F03226 to 0x03F0322D
3F03220 66780745 13110C05 66780713 [E.xf......xf]
SQL> alter system dump datafile 15 block 43; col 6: [ 7]
SQL> alter system checkpoint; Dump of memory from 0x03F0322E to 0x03F03235
3F03220 66780713 [..xf]
3F03230 13110C05 30321314 [......20]
col 7: [19]
Dump of memory from 0x03F03236 to 0x03F03249
3F03230 30321314 302D3230 32312D35 [..2002-05-12]
3F03240 3A36313A 313A3831 41560538 [:16:18:18.VA]
col 8: [ 5]
Dump of memory from 0x03F0324A to 0x03F0324F
3F03240 41560538 0144494C [8.VALID.]
col 9: [ 1]
Dump of memory from 0x03F03250 to 0x03F03251
3F03250 014E014E [N.N.]
col 10: [ 1]
Dump of memory from 0x03F03252 to 0x03F03253
3F03250 014E014E [N.N.]
col 11: [ 1]
Dump of memory from 0x03F03254 to 0x03F03255
3F03250 1A02064E [N...]
row#5[505] flag: K---S, lock: 2
col 0; len 26; (26):
41 54 54 52 49 42 55 54 45 5f 54 52 41 4e 53 46 4f 52 4d 41 54 49 4f 4e 53
24
tl: 70 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F03276 to 0x03F03279
3F03270 5953030C C203FF53 [..SYS...]
col 1: *NULL*
col 2: [ 3]
Dump of memory from 0x03F0327B to 0x03F0327E
3F03270 C203FF53 C2034E23 [S...#N..]
col 3: [ 3]
Dump of memory from 0x03F0327F to 0x03F03282
3F03270 C2034E23 [#N..]
3F03280 54054E23 [#N.T]
col 4: [ 5]
Dump of memory from 0x03F03283 to 0x03F03288
3F03280 54054E23 454C4241 [#N.TABLE]
col 5: [ 7]
Dump of memory from 0x03F03289 to 0x03F03290
3F03280 05667807 121B110C [.xf.....]
col 6: [ 7]
Dump of memory from 0x03F03291 to 0x03F03298
3F03290 05667807 121B110C [.xf.....]
col 7: [19]
Dump of memory from 0x03F03299 to 0x03F032AC
3F03290 30303213 35302D32 [.2002-05]
3F032A0 3A32312D 323A3631 37313A36 [-12:16:26:17]
col 8: [ 5]
Dump of memory from 0x03F032AD to 0x03F032B2
3F032A0 4C415605 [.VAL]
3F032B0 4E014449 [ID.N]
col 9: [ 1]
Dump of memory from 0x03F032B3 to 0x03F032B4
3F032B0 4E014449 [ID.N]
col 10: [ 1]
Dump of memory from 0x03F032B5 to 0x03F032B6
3F032B0 4E014E01 [.N.N]
col 11: [ 1]
Dump of memory from 0x03F032B7 to 0x03F032B8
3F032B0 4E014E01 [.N.N]
row#6[604] flag: K---S, lock: 2
col 0; len 4; (4): 41 55 44 24
tl: 68 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F032C3 to 0x03F032C6
3F032C0 53030C00 02FF5359 [...SYS..]
col 1: *NULL*
col 2: [ 2]
Dump of memory from 0x03F032C8 to 0x03F032CA
3F032C0 C10263C1 [.c..]
col 3: [ 2]
Dump of memory from 0x03F032CB to 0x03F032CD
3F032C0 C10263C1 41540563 [.c..c.TA]
col 4: [ 5]
Dump of memory from 0x03F032CE to 0x03F032D3
3F032C0 41540563 [c.TA]
3F032D0 07454C42 [BLE.]
col 5: [ 7]
Dump of memory from 0x03F032D4 to 0x03F032DB
3F032D0 0C056678 07071311 [xf......]
col 6: [ 7]
Dump of memory from 0x03F032DC to 0x03F032E3
3F032D0 0C056678 [xf..]
3F032E0 13121311 [....]
col 7: [19]
Dump of memory from 0x03F032E4 to 0x03F032F7
3F032E0 32303032 2D35302D 313A3231 [2002-05-12:1]
3F032F0 38313A36 0536303A [6:18:06.]
col 8: [ 5]
Dump of memory from 0x03F032F8 to 0x03F032FD
3F032F0 494C4156 014E0144 [VALID.N.]
col 9: [ 1]
Dump of memory from 0x03F032FE to 0x03F032FF
3F032F0 014E0144 [D.N.]
col 10: [ 1]
Dump of memory from 0x03F03300 to 0x03F03301
3F03300 064E014E [N.N.]
col 11: [ 1]
Dump of memory from 0x03F03302 to 0x03F03303
3F03300 064E014E [N.N.]
row#7[679] flag: K---S, lock: 2
col 0; len 6; (6): 41 55 44 49 54 24
tl: 70 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F03310 to 0x03F03313
3F03310 FF535953 [SYS.]
col 1: *NULL*
col 2: [ 3]
Dump of memory from 0x03F03315 to 0x03F03318
3F03310 3302C203 [...3]
col 3: [ 3]
Dump of memory from 0x03F03319 to 0x03F0331C
3F03310 3302C203 [...3]
col 4: [ 5]
Dump of memory from 0x03F0331D to 0x03F03322
3F03310 42415405 [.TAB]
3F03320 7807454C [LE.x]
col 5: [ 7]
Dump of memory from 0x03F03323 to 0x03F0332A
3F03320 7807454C 110C0566 78070913 [LE.xf......x]
col 6: [ 7]
Dump of memory from 0x03F0332B to 0x03F03332
3F03320 78070913 110C0566 [...xf...]
3F03330 32130913 [...2]
col 7: [19]
Dump of memory from 0x03F03333 to 0x03F03346
3F03330 32130913 2D323030 312D3530 36313A32 [...2002-05-12:16]
3F03340 3A38313A 56053830 [:18:08.V]
col 8: [ 5]
Dump of memory from 0x03F03347 to 0x03F0334C
3F03340 56053830 44494C41 [08.VALID]
col 9: [ 1]
Dump of memory from 0x03F0334D to 0x03F0334E
3F03340 4E014E01 [.N.N]
col 10: [ 1]
Dump of memory from 0x03F0334F to 0x03F03350
3F03340 4E014E01 [.N.N]
col 11: [ 1]
Dump of memory from 0x03F03351 to 0x03F03352
3F03350 02064E01 [.N..]
row#8[758] flag: K---S, lock: 2
col 0; len 13; (13): 41 55 44 49 54 5f 41 43 54 49 4f 4e 53
tl: 70 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F03366 to 0x03F03369
3F03360 5953030C C203FF53 [..SYS...]
col 1: *NULL*
col 2: [ 3]
Dump of memory from 0x03F0336B to 0x03F0336E
3F03360 C203FF53 C2032F16 [S..../..]
col 3: [ 3]
Dump of memory from 0x03F0336F to 0x03F03372
3F03360 C2032F16 [./..]
3F03370 54052F16 [./.T]
col 4: [ 5]
Dump of memory from 0x03F03373 to 0x03F03378
3F03370 54052F16 454C4241 [./.TABLE]
col 5: [ 7]
Dump of memory from 0x03F03379 to 0x03F03380
3F03370 05667807 3016110C [.xf....0]
col 6: [ 7]
Dump of memory from 0x03F03381 to 0x03F03388
3F03380 05667807 3116110C [.xf....1]
col 7: [19]
Dump of memory from 0x03F03389 to 0x03F0339C
3F03380 30303213 35302D32 [.2002-05]
3F03390 3A32312D 323A3631 37343A31 [-12:16:21:47]
col 8: [ 5]
Dump of memory from 0x03F0339D to 0x03F033A2
3F03390 4C415605 [.VAL]
3F033A0 4E014449 [ID.N]
col 9: [ 1]
Dump of memory from 0x03F033A3 to 0x03F033A4
3F033A0 4E014449 [ID.N]
col 10: [ 1]
Dump of memory from 0x03F033A5 to 0x03F033A6
3F033A0 4E014E01 [.N.N]
col 11: [ 1]
Dump of memory from 0x03F033A7 to 0x03F033A8
3F033A0 4E014E01 [.N.N]
row#9[844] flag: K---S, lock: 2
col 0; len 24; (24):
41 55 52 4f 52 41 24 53 48 55 54 44 4f 57 4e 24 43 4c 41 53 53 45 53 24
tl: 72 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F033C7 to 0x03F033CA
3F033C0 53030C00 04FF5359 [...SYS..]
col 1: *NULL*
col 2: [ 4]
Dump of memory from 0x03F033CC to 0x03F033D0
3F033C0 321503C3 [...2]
col 3: [ 4]
Dump of memory from 0x03F033D1 to 0x03F033D5
3F033D0 1503C304 41540532 [....2.TA]
col 4: [ 5]
Dump of memory from 0x03F033D6 to 0x03F033DB
3F033D0 41540532 07454C42 [2.TABLE.]
col 5: [ 7]
Dump of memory from 0x03F033DC to 0x03F033E3
3F033D0 0C056678 [xf..]
3F033E0 072C3711 [.7,.]
col 6: [ 7]
Dump of memory from 0x03F033E4 to 0x03F033EB
3F033E0 0C056678 132C3711 [xf...7,.]
col 7: [19]
Dump of memory from 0x03F033EC to 0x03F033FF
3F033E0 32303032 [2002]
3F033F0 2D35302D 313A3231 34353A36 0533343A [-05-12:16:54:43.]
col 8: [ 5]
Dump of memory from 0x03F03400 to 0x03F03405
3F03400 494C4156 014E0144 [VALID.N.]
col 9: [ 1]
Dump of memory from 0x03F03406 to 0x03F03407
3F03400 014E0144 [D.N.]
col 10: [ 1]
Dump of memory from 0x03F03408 to 0x03F03409
3F03400 064E014E [N.N.]
col 11: [ 1]
Dump of memory from 0x03F0340A to 0x03F0340B
3F03400 064E014E [N.N.]
row#10[943] flag: K---S, lock: 2
col 0; len 23; (23):
41 55 52 4f 52 41 24 53 54 41 52 54 55 50 24 43 4c 41 53 53 45 53 24
tl: 72 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F03429 to 0x03F0342C
3F03420 53595303 [.SYS]
col 1: *NULL*
col 2: [ 4]
Dump of memory from 0x03F0342E to 0x03F03432
3F03420 03C304FF [....]
3F03430 C3043115 [.1..]
col 3: [ 4]
Dump of memory from 0x03F03433 to 0x03F03437
3F03430 C3043115 05311503 [.1....1.]
col 4: [ 5]
Dump of memory from 0x03F03438 to 0x03F0343D
3F03430 4C424154 66780745 [TABLE.xf]
col 5: [ 7]
Dump of memory from 0x03F0343E to 0x03F03445
3F03430 66780745 [E.xf]
3F03440 37110C05 6678072C [...7,.xf]
col 6: [ 7]
Dump of memory from 0x03F03446 to 0x03F0344D
3F03440 6678072C 37110C05 3032132C [,.xf...7,.20]
col 7: [19]
Dump of memory from 0x03F0344E to 0x03F03461
3F03440 3032132C [,.20]
3F03450 302D3230 32312D35 3A36313A 343A3435 [02-05-12:16:54:4]
3F03460 41560533 [3.VA]
col 8: [ 5]
Dump of memory from 0x03F03462 to 0x03F03467
3F03460 41560533 0144494C [3.VALID.]
col 9: [ 1]
Dump of memory from 0x03F03468 to 0x03F03469
3F03460 014E014E [N.N.]
col 10: [ 1]
Dump of memory from 0x03F0346A to 0x03F0346B
3F03460 014E014E [N.N.]
col 11: [ 1]
Dump of memory from 0x03F0346C to 0x03F0346D
3F03460 0A02064E [N...]
row#11[1041] flag: K---S, lock: 2
col 0; len 10; (10): 41 55 58 5f 53 54 41 54 53 24
tl: 70 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F0347E to 0x03F03481
3F03470 5953030C [..SY]
3F03480 C203FF53 [S...]
col 1: *NULL*
col 2: [ 3]
Dump of memory from 0x03F03483 to 0x03F03486
3F03480 C203FF53 C2030D06 [S.......]
col 3: [ 3]
Dump of memory from 0x03F03487 to 0x03F0348A
3F03480 C2030D06 54050D06 [.......T]
col 4: [ 5]
Dump of memory from 0x03F0348B to 0x03F03490
3F03480 54050D06 454C4241 [...TABLE]
col 5: [ 7]
Dump of memory from 0x03F03491 to 0x03F03498
3F03490 05667807 3813110C [.xf....8]
col 6: [ 7]
Dump of memory from 0x03F03499 to 0x03F034A0
3F03490 05667807 3619110C [.xf....6]
col 7: [19]
Dump of memory from 0x03F034A1 to 0x03F034B4
3F034A0 30303213 35302D32 3A32312D 313A3631 [.2002-05-12:16:1]
3F034B0 35353A38 [8:55]
col 8: [ 5]
Dump of memory from 0x03F034B5 to 0x03F034BA
3F034B0 4C415605 4E014449 [.VALID.N]
col 9: [ 1]
Dump of memory from 0x03F034BB to 0x03F034BC
3F034B0 4E014449 [ID.N]
col 10: [ 1]
Dump of memory from 0x03F034BD to 0x03F034BE
3F034B0 4E014E01 [.N.N]
col 11: [ 1]
Dump of memory from 0x03F034BF to 0x03F034C0
3F034B0 4E014E01 [.N.N]
row#12[1124] flag: K---S, lock: 2
col 0; len 3; (3): 41 57 24
tl: 70 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F034CA to 0x03F034CD
3F034C0 5953030C C203FF53 [..SYS...]
col 1: *NULL*
col 2: [ 3]
Dump of memory from 0x03F034CF to 0x03F034D2
3F034C0 C203FF53 [S...]
3F034D0 C2031206 [....]
col 3: [ 3]
Dump of memory from 0x03F034D3 to 0x03F034D6
3F034D0 C2031206 54051206 [.......T]
col 4: [ 5]
Dump of memory from 0x03F034D7 to 0x03F034DC
3F034D0 54051206 454C4241 [...TABLE]
col 5: [ 7]
Dump of memory from 0x03F034DD to 0x03F034E4
3F034D0 05667807 [.xf.]
3F034E0 3813110C [...8]
col 6: [ 7]
Dump of memory from 0x03F034E5 to 0x03F034EC
3F034E0 05667807 0D3C120C [.xf...<.]
col 7: [19]
Dump of memory from 0x03F034ED to 0x03F03500
3F034E0 30303213 [.200]
3F034F0 35302D32 3A32312D 313A3631 35353A38 [2-05-12:16:18:55]
col 8: [ 5]
Dump of memory from 0x03F03501 to 0x03F03506
3F03500 4C415605 4E014449 [.VALID.N]
col 9: [ 1]
Dump of memory from 0x03F03507 to 0x03F03508
3F03500 4E014449 [ID.N]
col 10: [ 1]
Dump of memory from 0x03F03509 to 0x03F0350A
3F03500 4E014E01 [.N.N]
col 11: [ 1]
Dump of memory from 0x03F0350B to 0x03F0350C
3F03500 4E014E01 [.N.N]
row#13[1200] flag: K---S, lock: 2
col 0; len 11; (11): 41 57 24 43 57 4d 54 4f 45 43 4d
tl: 72 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F0351E to 0x03F03521
3F03510 5953030C [..SY]
3F03520 C304FF53 [S...]
col 1: *NULL*
col 2: [ 4]
Dump of memory from 0x03F03523 to 0x03F03527
3F03520 C304FF53 044E5603 [S....VN.]
col 3: [ 4]
Dump of memory from 0x03F03528 to 0x03F0352C
3F03520 4E5603C3 [..VN]
col 4: [ 5]
Dump of memory from 0x03F0352D to 0x03F03532
3F03520 42415405 [.TAB]
3F03530 7807454C [LE.x]
col 5: [ 7]
Dump of memory from 0x03F03533 to 0x03F0353A
3F03530 7807454C 120C0566 7807383A [LE.xf...:8.x]
col 6: [ 7]
Dump of memory from 0x03F0353B to 0x03F03542
3F03530 7807383A 120C0566 [:8.xf...]
3F03540 32131D3B [;..2]
col 7: [19]
Dump of memory from 0x03F03543 to 0x03F03556
3F03540 32131D3B 2D323030 312D3530 37313A32 [;..2002-05-12:17]
3F03550 3A37353A 56053535 [:57:55.V]
col 8: [ 5]
Dump of memory from 0x03F03557 to 0x03F0355C
3F03550 56053535 44494C41 [55.VALID]
col 9: [ 1]
Dump of memory from 0x03F0355D to 0x03F0355E
3F03550 4E014E01 [.N.N]
col 10: [ 1]
Dump of memory from 0x03F0355F to 0x03F03560
3F03550 4E014E01 [.N.N]
col 11: [ 1]
Dump of memory from 0x03F03561 to 0x03F03562
3F03560 02064E01 [.N..]
row#14[1286] flag: K---S, lock: 2
col 0; len 10; (10): 41 57 24 45 58 50 52 45 53 53
tl: 72 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F03573 to 0x03F03576
3F03570 53030C00 04FF5359 [...SYS..]
col 1: *NULL*
col 2: [ 4]
Dump of memory from 0x03F03578 to 0x03F0357C
3F03570 4A5603C3 [..VJ]
col 3: [ 4]
Dump of memory from 0x03F0357D to 0x03F03581
3F03570 5603C304 [...V]
3F03580 4154054A [J.TA]
col 4: [ 5]
Dump of memory from 0x03F03582 to 0x03F03587
3F03580 4154054A 07454C42 [J.TABLE.]
col 5: [ 7]
Dump of memory from 0x03F03588 to 0x03F0358F
3F03580 0C056678 071B3A12 [xf...:..]
col 6: [ 7]
Dump of memory from 0x03F03590 to 0x03F03597
3F03590 0C056678 13383A12 [xf...:8.]
col 7: [19]
Dump of memory from 0x03F03598 to 0x03F035AB
3F03590 32303032 2D35302D [2002-05-]
3F035A0 313A3231 37353A37 0536323A [12:17:57:26.]
col 8: [ 5]
Dump of memory from 0x03F035AC to 0x03F035B1
3F035A0 494C4156 [VALI]
3F035B0 014E0144 [D.N.]
col 9: [ 1]
Dump of memory from 0x03F035B2 to 0x03F035B3
3F035B0 014E0144 [D.N.]
col 10: [ 1]
Dump of memory from 0x03F035B4 to 0x03F035B5
3F035B0 064E014E [N.N.]
col 11: [ 1]
Dump of memory from 0x03F035B6 to 0x03F035B7
3F035B0 064E014E [N.N.]
row#15[1371] flag: K---S, lock: 2
col 0; len 10; (10): 42 4f 4f 54 53 54 52 41 50 24
tl: 68 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F035C8 to 0x03F035CB
3F035C0 FF535953 [SYS.]
col 1: *NULL*
col 2: [ 2]
Dump of memory from 0x03F035CD to 0x03F035CF
3F035C0 0239C102 [..9.]
col 3: [ 2]
Dump of memory from 0x03F035D0 to 0x03F035D2
3F035D0 540539C1 [.9.T]
col 4: [ 5]
Dump of memory from 0x03F035D3 to 0x03F035D8
3F035D0 540539C1 454C4241 [.9.TABLE]
col 5: [ 7]
Dump of memory from 0x03F035D9 to 0x03F035E0
3F035D0 05667807 0113110C [.xf.....]
col 6: [ 7]
Dump of memory from 0x03F035E1 to 0x03F035E8
3F035E0 05667807 0113110C [.xf.....]
col 7: [19]
Dump of memory from 0x03F035E9 to 0x03F035FC
3F035E0 30303213 35302D32 [.2002-05]
3F035F0 3A32312D 313A3631 30303A38 [-12:16:18:00]
col 8: [ 5]
Dump of memory from 0x03F035FD to 0x03F03602
3F035F0 4C415605 [.VAL]
3F03600 4E014449 [ID.N]
col 9: [ 1]
Dump of memory from 0x03F03603 to 0x03F03604
3F03600 4E014449 [ID.N]
col 10: [ 1]
Dump of memory from 0x03F03605 to 0x03F03606
3F03600 4E014E01 [.N.N]
col 11: [ 1]
Dump of memory from 0x03F03607 to 0x03F03608
3F03600 4E014E01 [.N.N]
row#16[1452] flag: K---S, lock: 2
col 0; len 5; (5): 43 43 4f 4c 24
tl: 68 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F03614 to 0x03F03617
3F03610 FF535953 [SYS.]
col 1: *NULL*
col 2: [ 2]
Dump of memory from 0x03F03619 to 0x03F0361B
3F03610 0221C102 [..!.]
col 3: [ 2]
Dump of memory from 0x03F0361C to 0x03F0361E
3F03610 54051EC1 [...T]
col 4: [ 5]
Dump of memory from 0x03F0361F to 0x03F03624
3F03610 54051EC1 [...T]
3F03620 454C4241 [ABLE]
col 5: [ 7]
Dump of memory from 0x03F03625 to 0x03F0362C
3F03620 05667807 0113110C [.xf.....]
col 6: [ 7]
Dump of memory from 0x03F0362D to 0x03F03634
3F03620 05667807 [.xf.]
3F03630 0B3C120C [..<.]
col 7: [19]
Dump of memory from 0x03F03635 to 0x03F03648
3F03630 30303213 35302D32 3A32312D [.2002-05-12:]
3F03640 313A3631 30303A38 [16:18:00]
col 8: [ 5]
Dump of memory from 0x03F03649 to 0x03F0364E
3F03640 4C415605 4E014449 [.VALID.N]
col 9: [ 1]
Dump of memory from 0x03F0364F to 0x03F03650
3F03640 4E014449 [ID.N]
col 10: [ 1]
Dump of memory from 0x03F03651 to 0x03F03652
3F03650 4E014E01 [.N.N]
col 11: [ 1]
Dump of memory from 0x03F03653 to 0x03F03654
3F03650 4E014E01 [.N.N]
row#17[1528] flag: K---S, lock: 2
col 0; len 19; (19): 43 44 43 5f 43 48 41 4e 47 45 5f 43 4f 4c 55 4d 4e 53 24
tl: 70 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F0366E to 0x03F03671
3F03660 5953030C [..SY]
3F03670 C203FF53 [S...]
col 1: *NULL*
col 2: [ 3]
Dump of memory from 0x03F03673 to 0x03F03676
3F03670 C203FF53 C2035A05 [S....Z..]
col 3: [ 3]
Dump of memory from 0x03F03677 to 0x03F0367A
3F03670 C2035A05 54055A05 [.Z...Z.T]
col 4: [ 5]
Dump of memory from 0x03F0367B to 0x03F03680
3F03670 54055A05 454C4241 [.Z.TABLE]
col 5: [ 7]
Dump of memory from 0x03F03681 to 0x03F03688
3F03680 05667807 3613110C [.xf....6]
col 6: [ 7]
Dump of memory from 0x03F03689 to 0x03F03690
3F03680 05667807 3613110C [.xf....6]
col 7: [19]
Dump of memory from 0x03F03691 to 0x03F036A4
3F03690 30303213 35302D32 3A32312D 313A3631 [.2002-05-12:16:1]
3F036A0 33353A38 [8:53]
col 8: [ 5]
Dump of memory from 0x03F036A5 to 0x03F036AA
3F036A0 4C415605 4E014449 [.VALID.N]
col 9: [ 1]
Dump of memory from 0x03F036AB to 0x03F036AC
3F036A0 4E014449 [ID.N]
col 10: [ 1]
Dump of memory from 0x03F036AD to 0x03F036AE
3F036A0 4E014E01 [.N.N]
col 11: [ 1]
Dump of memory from 0x03F036AF to 0x03F036B0
3F036A0 4E014E01 [.N.N]
row#18[1620] flag: K---S, lock: 2
col 0; len 16; (16): 43 44 43 5f 43 48 41 4e 47 45 5f 53 45 54 53 24
tl: 70 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F036C7 to 0x03F036CA
3F036C0 53030C00 03FF5359 [...SYS..]
col 1: *NULL*
col 2: [ 3]
Dump of memory from 0x03F036CC to 0x03F036CF
3F036C0 034F05C2 [..O.]
col 3: [ 3]
Dump of memory from 0x03F036D0 to 0x03F036D3
3F036D0 054F05C2 [..O.]
col 4: [ 5]
Dump of memory from 0x03F036D4 to 0x03F036D9
3F036D0 4C424154 66780745 [TABLE.xf]
col 5: [ 7]
Dump of memory from 0x03F036DA to 0x03F036E1
3F036D0 66780745 13110C05 [E.xf....]
3F036E0 66780735 [5.xf]
col 6: [ 7]
Dump of memory from 0x03F036E2 to 0x03F036E9
3F036E0 66780735 13110C05 30321335 [5.xf....5.20]
col 7: [19]
Dump of memory from 0x03F036EA to 0x03F036FD
3F036E0 30321335 302D3230 [5.2002-0]
3F036F0 32312D35 3A36313A 353A3831 41560532 [5-12:16:18:52.VA]
col 8: [ 5]
Dump of memory from 0x03F036FE to 0x03F03703
3F036F0 41560532 [2.VA]
3F03700 0144494C [LID.]
col 9: [ 1]
Dump of memory from 0x03F03704 to 0x03F03705
3F03700 014E014E [N.N.]
col 10: [ 1]
Dump of memory from 0x03F03706 to 0x03F03707
3F03700 014E014E [N.N.]
col 11: [ 1]
Dump of memory from 0x03F03708 to 0x03F03709
3F03700 1302064E [N...]
row#19[1709] flag: K---S, lock: 2
col 0; len 19; (19): 43 44 43 5f 43 48 41 4e 47 45 5f 53 4f 55 52 43 45 53 24
tl: 70 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F03723 to 0x03F03726
3F03720 53030C00 03FF5359 [...SYS..]
col 1: *NULL*
col 2: [ 3]
Dump of memory from 0x03F03728 to 0x03F0372B
3F03720 034D05C2 [..M.]
col 3: [ 3]
Dump of memory from 0x03F0372C to 0x03F0372F
3F03720 054D05C2 [..M.]
col 4: [ 5]
Dump of memory from 0x03F03730 to 0x03F03735
3F03730 4C424154 66780745 [TABLE.xf]
col 5: [ 7]
Dump of memory from 0x03F03736 to 0x03F0373D
3F03730 66780745 13110C05 66780735 [E.xf....5.xf]
col 6: [ 7]
Dump of memory from 0x03F0373E to 0x03F03745
3F03730 66780735 [5.xf]
3F03740 13110C05 30321335 [....5.20]
col 7: [19]
Dump of memory from 0x03F03746 to 0x03F03759
3F03740 30321335 302D3230 32312D35 [5.2002-05-12]
3F03750 3A36313A 353A3831 41560532 [:16:18:52.VA]
col 8: [ 5]
Dump of memory from 0x03F0375A to 0x03F0375F
3F03750 41560532 0144494C [2.VALID.]
col 9: [ 1]
Dump of memory from 0x03F03760 to 0x03F03761
3F03760 014E014E [N.N.]
col 10: [ 1]
Dump of memory from 0x03F03762 to 0x03F03763
3F03760 014E014E [N.N.]
col 11: [ 1]
Dump of memory from 0x03F03764 to 0x03F03765
3F03760 1202064E [N...]
row#20[1801] flag: K---S, lock: 2
col 0; len 18; (18): 43 44 43 5f 43 48 41 4e 47 45 5f 54 41 42 4c 45 53 24
tl: 70 fb: --H-FL-- lb: 0x0 cc: 12
col 0: [ 3]
Dump of memory from 0x03F0377E to 0x03F03781
3F03770 5953030C [..SY]
3F03780 C203FF53 [S...]
col 1: *NULL*
col 2: [ 3]
Dump of memory from 0x03F03783 to 0x03F03786
3F03780 C203FF53 C2035105 [S....Q..]
col 3: [ 3]
Dump of memory from 0x03F03787 to 0x03F0378A
3F03780 C2035105 54055105 [.Q...Q.T]
col 4: [ 5]
Dump of memory from 0x03F0378B to 0x03F03790
3F03780 54055105 454C4241 [.Q.TABLE]
col 5: [ 7]
Dump of memory from 0x03F03791 to 0x03F03798
3F03790 05667807 3513110C [.xf....5]
col 6: [ 7]
Dump of memory from 0x03F03799 to 0x03F037A0
3F03790 05667807 3613110C [.xf....6]
col 7: [19]
Dump of memory from 0x03F037A1 to 0x03F037B4
3F037A0 30303213 35302D32 3A32312D 313A3631 [.2002-05-12:16:1]
3F037B0 32353A38 [8:52]
col 8: [ 5]
Dump of memory from 0x03F037B5 to 0x03F037BA
3F037B0 4C415605 4E014449 [.VALID.N]
col 9: [ 1]
Dump of memory from 0x03F037BB to 0x03F037BC
3F037B0 4E014449 [ID.N]
col 10: [ 1]
Dump of memory from 0x03F037BD to 0x03F037BE
3F037B0 4E014E01 [.N.N]
col 11: [ 1]
Dump of memory from 0x03F037BF to 0x03F037C0
3F037B0 4E014E01 [.N.N]
----- end of leaf 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:0x03C0002B
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.0094A272
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:0x06
2 - last change to the block was for a cleanout operation +4 - checksum value is set
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:0xA9D4
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: 0x00007ABB
(31419)
13
Cleanout system change,used to show when block cleanout was last performed.
csc: 0x00.94A252
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.
0x000A.0012.00001FD5
19
Rollback segment.
XID:undoseg 10
20
Refers to a slot in the transaction table.
XID:slot# 18
21
Refers to the number of times that the slot has been used (i.e. incarnation or version) in a transaction.
XID:wrap 8149
22
The UBA is the pointer to the tail of the undo chain for the block.
UBA:(undodatablockaddr.sequence#.record#): 0x00800034.0413.05
23
DBA of the rollback segment block.
0x00800034
file- 2 block- 52
24
Sequence 1043
25
Record number for the change in that undo block - 5
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: -BU-
Lck
The number of row-level locks held in the block by this transaction
Lck: 1

(0110 -0000 0000 0001)
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: 0x0094A254
29
Index level (0 represents leaf blocks).
kdxcolev: 0
30
Denotes whether structural block transaction is occurring.
kdxcolok:1
31
Iinternal operation code.
kdxcoopc: 0x90: opcode=0: iot flags=I-- is converted=Y
32
Index column count.
kdxconco:1
33
Count of index structural changes involving lock.
kdxcosdc:2
34
Number of index entries -does not include kdxbrlmc pointer.
kdxconro:21
35
Free space begin offset.
kdxcofbo:0x004E
36
Free space end offset.
kdxcofeo:0x0062
37
Available space in the block.
kdxcoavs:20
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: 0x03C0002C
41
Pointer to the previous leaf block in the index structure via corresponding RDBA.
kdxleprv: 0x03C0004B
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 @0x62(98)
46
Begin free space.
47
Row =0. Key.
flag: K---S
48
Lock byte.
Corresponds with above ITL lck expresses this line whether by lock
lb: 0x2

49
len 9
50
"ARGUMENT$"
51
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 )
52
Lock byte.
Corresponds with above ITL lck expresses this line whether by lock
lb: 0x0

53
column count
cc: 12

54
len 3
55
"SYS"
56
NULL
57
len 2
58
70
59
len 2
60
70
61
len 5
62
"TABLE"
63
len 7
64
12.05.2002 16:18:04
65
len 7
66
12.05.2002 17:29:55
67
"2002-05-12:16:18:04"
68
len 5
69
"VALID"

70
len 1
71
0
72
len 1
73
0
74
len 1
75
0
76
row =1
77
row =2
78
row =3
79
row =4
80
row =5
81
row =6
82
row =7
83
row =8
84
row =9
85
row =10
86
row =11
87
row =12
88
row =13
89
row =14
90
row =15
91
row =16
92
row =17
93
row =18
94
row =19
95
row =20
96
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:0xA2720601