2.5 hmw概念
high water mark代表一个表使用的最大的(top limit)块 。2.1中已经提到high water mark 记录在segment header中,并且在oracle插入数据时一般增长5个blocks(并非总是5个块,具体参见2.4.2中流程图中hmw增长方式)。
segment header block中与hwm相关信息说明如下:
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)