This is a dump of an index block.
I need to interpret the actual data (my understanding it should be
rowid, col1, col2 (it's a PK on two columns).
Any hints, links appreciated.
Thanx.
- 2002-05-14 11:12:39.954
- SESSION ID:(1597.11880) 2002-05-14 11:12:39.941
Start dump data blocks tsn: 6 file#: 30 minblk 243909 maxblk 243909
buffer tsn: 6 rdba: 0x0783b8c5 (30/243909)
scn: 0x0000.7e377287 seq: 0x02 flg: 0x00 tail: 0x72870602
frmt: 0x02 chkval: 0x0000 type: 0x06=trans data
Block header dump: 0x0783b8c5
Object id on Block? Y
seg/obj: 0x4a38 csc: 0x00.7e020f28 itc: 4 flg: - typ: 2 - INDEX
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck
Scn/Fsc
0x01 xid: 0x0004.014.0019b136 uba: 0x0081d8c6.5435.02 C--- 0
scn 0x0000.7b
260df8
0x02 xid: 0x0006.01c.000202ac uba: 0x0f415996.0422.08 ---- 30
fsc 0x050a.00
000000
0x03 xid: 0x0000.000.00000000 uba: 0x00000000.0000.00 ---- 0
fsc 0x0000.00
000000
0x04 xid: 0x0000.000.00000000 uba: 0x00000000.0000.00 ---- 0
fsc 0x0000.00
000000
Leaf block dump
header address 27579884=0x1a4d5ec
kdxcolev 0
kdxcolok 0
kdxcoopc 0x80: opcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 1
kdxconro 49
kdxcofbo 134=0x86
kdxcofeo 1899=0x76b
kdxcoavs 1765
kdxlespl 0
kdxlende 30
kdxlenxt 50522048=0x302e7c0
kdxleprv 96712106=0x5c3b5aa
kdxledsz 6
kdxlebksz 3888
row#0[1899] flag: ---D-, lock: 2, data:(6): 02 01 96 f0 00 13
col 0; len 24; (24):
30 30 32 30 66 30 31 39 63 61 35 35 37 34 33 62 64 30 30 39 37 64 30
33
col 1; len 7; (7): 75 73 65 72 5f 69 64
row#1[1940] flag: ---D-, lock: 2, data:(6): 02 01 96 f0 00 2c
col 0; len 24; (24):
30 30 32 30 66 30 31 39 63 61 35 35 37 34 33 62 64 30 30 39 38 38 30
36
col 1; len 7; (7): 75 73 65 72 5f 69 64
...
.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes
remove NSPAM to email
Received on Tue May 14 2002 - 12:19:10 CDT
