Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interpreting an index data block dump

Daryl E.Mar 24 2011 — edited Mar 25 2011
I have seen a few postings about reading index data blocks, mine doesnt quite look like those.
Ok: 11Gr1 (linux)
Tracing down a hot block issue with an index, I performed
alter system dump datafile 11 block 4030208;

Looking at the Web page "Index Block Dump: Index Only Section Part II (Station To Station)" and others they show a dump like this:
row#0[8021] flag: ——, lock: 0, len=15
col 0; len 5; (5): 42 4f 57 49 45
col 1; len 6; (6): 02 01 48 8a 00 00
row#1[8002] flag: ——, lock: 0, len=19
col 0; len 9; (9): 4d 41 4a 4f 52 20 54 4f 4d
col 1; len 6; (6): 02 01 48 8a 00 02
row#2[7987] flag: ——, lock: 0, len=15
col 0; len 5; (5): 5a 49 47 47 59
col 1; len 6; (6): 02 01 48 8a 00 01
—– end of leaf block dump —–
End dump data blocks tsn: 8 file#: 8 minblk 84234 maxblk 84234



I dont see anything that "obvious" in my dump. Am I looking at something other then an leaf block perhaps?

I am expecting/hoping to see some sort of pairs for an index like X(y number, z number)
Block dump from cache:
Dump of buffer cache at level 4 for tsn=6, rdba=50167552
BH (0x275f2aec8) file#: 11 rdba: 0x02fd7f00 (11/4030208) class: 4 ba: 0x274992000
  set: 111 bsz: 8192 bsi: 0 sflg: 0 pwc: 0, 25 lid: 0x00000000,0x00000000
  dbwrid: 2 obj: 127499 objn: 77784 tsn: 6 afn: 11
  hash: [0x403d34650,0x403d34650] lru: [0x333f32878,0x209f4ea88]
  lru-flags: hot_buffer
  ckptq: [NULL] fileq: [NULL] objq: [0x22dede3f8,0x30ff9c3f8]
  st: XCURRENT md: NULL tch: 2
  flags: block_written_once redo_since_read gotten_in_current_mode
  LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [34]
  cr pin refcnt: 0 sh pin refcnt: 0
  buffer tsn: 6 rdba: 0x02fd7f00 (11/4030208)
  scn: 0x0001.19bccf84 seq: 0x02 flg: 0x04 tail: 0xcf841002
  frmt: 0x02 chkval: 0x987f type: 0x10=DATA SEGMENT HEADER - UNLIMITED
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0000000274992000 to 0x0000000274994000
274992000 0000A210 02FD7F00 19BCCF84 04020001  [................]
...
274993FF0 00000000 00000000 00000000 CF841002  [................]
  Extent Control Header
  -----------------------------------------------------------------
  Extent Header:: spare1: 0      spare2: 0      #extents: 66     #blocks: 10239
                  last map  0x00000000  #maps: 0      offset: 4128
      Highwater::  0x047feb5b  ext#: 65     blk#: 731    ext size: 1024
  #blocks in seg. hdr's freelists: 0
  #blocks below: 9946
  mapblk  0x00000000  offset: 65
                   Unlocked
     Map Header:: next  0x00000000  #extents: 66   obj#: 127499 flag: 0x40000000
  Extent Map
  -----------------------------------------------------------------
   0x02fd7f01  length: 127
   0x0339ea80  length: 128
...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2011
Added on Mar 24 2011
8 comments
1,104 views