Blockdump

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

• ·Oracle iAS 10g Report S
• ·[Oracle] 书写历史的甲骨文――ORAC
• ·创建实体化视图产生ORA-600 [ksmov
• ·oracle怎样按物理顺序提取记录？(from
• ·Oracle Freelist和HWM原理探讨
• ·Data Blocks and Freelis
• ·oracle8i for unixware安装
• ·如何在WINDOWS 2000将ORALCE完
• ·在Linux下安装Oracle9i
• ·学习oracle sql loader 的使用