Blockdump-8.xDataSegmentHeaderinOracle
发表于:2007-05-25来源:作者:点击数:
标签:
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 - UNLI MI TEDEXTENT CONTROL: Extent Header:: spare1: 0 space2: 0 #extents: 13 #blocks: 142
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 - UNLIMITED
EXTENT 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 displayed
EXTENT 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 V8
Map Extent:
==> dba: dba of extent
==> length: number of blocks in extent
FREE 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 lists
Segment List:
==> flg: flag USED or UNUSED the free list
==> lhd: head of free list
==> ltl: tail of free list
原文转自:http://www.ltesting.net
|