Blockdump - 8.x Data Segment Header in Oracle
2024-08-29 13:30:02
供稿：网友
subject: qref: blockdump - 8.x data segment header in oracle creation date: 25-apr-2000 cache block:see note: 47132.1 type: 0x10=data segment header - unlimitedextent control: extent header:: spare1: 0 space2: 0 #extents: 13 #blocks: 1429 last map 0x00000000 #maps: 0 offset: 4128 highwater:: 0x020004d0 ext#: 12 blk#: 275 ext size: 475 #blocks in seg. hdr's freelists: 5 #blocks below: 1229 mapblk 0x00000000 offset: 12 unlocked==> spare1: this field is no longer used (old inc#, now always 0)==> space2: this field is no longer used (old ts#, now always 0)==> #extents: number of extents allocated to segment==> #blocks: number of blocks allocated to segment==> last map: address of last extent map block 0 if extent map is entirely in the segment header==> #maps: number of extent map block==> offset: offset to end of extent map==> hwm dba: address of block at highwater mark==> ext#: hwm extent number relative to segment==> blk#: hwm block number within extent==> ext size: hwm extent size (in blocks)==> #blocks in seg. hdr's freelists: number of blocks in seg. hdr's free list ==> #blocks below: number of blocks below hwm==> mapblk dba: dba of extent map block containing hwm extent is 0 if hwm is in the segment header==> offset: offset within extent map block is the ext# if hwm is in segment header==> locked by: if locked by a transaction, the xid is displayedextent map:map header:: next 0x00000000 #extents: 13 obj#: 12141 flag: 0x40000000 0x02000003 length: 4 0x02000007 length: 5 0x0200000c length: 10 0x02000016 length: 15 0x02000025 length: 20 0x02000039 length: 30 0x02000057 length: 45 0x02000084 length: 65 0x020000c5 length: 95 0x02000124 length: 140 0x020001b0 length: 210 0x02000282 length: 315 0x020003bd length: 475 map header:==> next dba: address of next extent map block==> #extents: number of extents in this extent map block==> obj#: object id for this segment==> flag: flag to mark the version of segment header is 2 if the segment header is v8map extent:==> dba: dba of extent==> length: number of blocks in extentfree list: nfl = 1, nfb = 1 typ = 1 nxf = 0 seg lst:: flg: used lhd: 0x020004cb ltl: 0x020004cf segment header:==> nfl: number of free lists/block==> nfb: number of free list blocks + segment header==> typ: block type ==> nxf: number of transaction free listssegment list:==> flg: flag used or unused the free list==> lhd: head of free list==> ltl: tail of free list
