Re: interpreting block dump

For interpreting the col0 and col1 ....
Col1 could be a date as it's 7bytes in both rows ... col0 could char or varchar2
To check this - it's object id 0x4a38 -> 19000 dec -> select blah, blah from dba_objects where rowid = 19000 ; -> select blah, blah form dba_indexes where index_name = xxx ;

if col0 is a char or varchar : get an ascii table and map to characters if col1 is a date :
  BYTE Meaning

• ------- 1 Century -- stored in excess-100 notation 2 Year -- " " 3 Month -- stored in 0 base notation 4 Day -- " " 5 Hour -- stored in excess-1 notation 6 Minute -- " " 7 Second -- " "

Check Note:69028.1 How does Oracle store the DATE datatype internally? on metalink

"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message news:3ce14702.92152618_at_news.globix.com...
> 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 - 13:00:12 CDT