浅谈Oracle的高水位线--HWM

        高 水位是记录段里能容纳数据的上限，高水位存在段里

       全表扫先读段头块，而后在段头块里面找到HWM

        下面用实验由内而外来理解Oracle的HWM

--t表有一条数据

hr@ORCL> select * from t;

        ID NAME
---------- ----------
         1 AAAAA

--找t段的段头块

hr@ORCL> select header_file,header_block from dba_segments where segment_name='T' and owner='HR';

HEADER_FILE HEADER_BLOCK
----------- ------------
          4          387

--另开一个session，dump段头块

sys@ORCL> alter session set tracefile_identifier='sys_dump_t_01';

Session altered.

sys@ORCL> alter system dump datafile 4 block 387;

System altered.

       dump的部分trc内容摘入

  Extent Control Header
  -----------------------------------------------------------------
  Extent Header:: spare1: 0      spare2: 0      #extents: 1      #blocks: 8
                  last map  0x00000000  #maps: 0      offset: 2716
      Highwater::  0x01000189  ext#: 0      blk#: 8      ext size: 8   --Highwater就是高水位，0x01000189这个是HWM的地址
  #blocks in seg. hdr's freelists: 0
  #blocks below: 5
  mapblk  0x00000000  offset: 0
                   Unlocked
  --------------------------------------------------------
  Low HighWater Mark :
      Highwater::  0x01000189  ext#: 0      blk#: 8      ext size: 8
  #blocks in seg. hdr's freelists: 0
  #blocks below: 5
  mapblk  0x00000000  offset: 0
  Level 1 BMB for High HWM block: 0x01000181
  Level 1 BMB for Low HWM block: 0x01000181
  --------------------------------------------------------
  Segment Type: 1 nl2: 1      blksz: 8192   fbsz