append 与 Highwater 测试-开发技术-Oracle频道-中国IT实验室

SQL> create table test_block as select * from dba_objects where 1 = 0;

 

表已创建。

 

SQL> select OWNER, SEGMENT_NAME, HEADER_FILE, HEADER_BLOCK, BLOCKS, EXTENTS, FREELISTS
  2    from dba_segments
  3   where segment_name = 'TEST_BLOCK';

 

SEGMENT_NAME  HEADER_FILE HEADER_BLOCK  BLOCKS   EXTENTS
------------- ----------- ------------ ------- ---------
TEST_BLOCK             11          193       8         1

 

 

SQL> select EXTENT_ID, FILE_ID, BLOCK_ID, BYTES, BLOCKS, RELATIVE_FNO
  2    from dba_extents
  3   where segment_name = 'TEST_BLOCK';

 

 EXTENT_ID    FILE_ID   BLOCK_ID      BYTES     BLOCKS RELATIVE_FNO
---------- ---------- ---------- ---------- ---------- ------------
         0         11        193      65536          8           11

 

SQL> insert into test_block select * from dba_objects where rownum < 12;

 

已创建 11 行。

 

SQL> select dbms_rowid.rowid_relative_fno(rowid) file#,
  2         dbms_rowid.rowid_block_number(rowid) block#
  3    from test_block;

 

     FILE#     BLOCK#
---------- ----------
        11        194
        11        194
        11        194
        11        194
        11        194
        11        194
        11        194
        11        194
        11        194
        11        194

        11        194

 

已选择11行。

 

--------------------next---------------------

*** 2008-05-30 11:24:07.000
Start dump data blocks tsn: 11 file#: 11 minblk 193 maxblk 193
buffer tsn: 11 rdba: 0x02c000c1 (11/193)
scn: 0x0000.1bf3af2f seq: 0x01 flg: 0x00 tail: 0xaf2f1001
frmt: 0x02 chkval: 0x0000 type: 0x10=DATA SEGMENT HEADER - UNLIMITED
  Extent Control Header
  -----------------------------------------------------------------
  Extent Header:: spare1: 0      spare2: 0      #extents: 1      #blocks: 7    
                  last map  0x00000000  #maps: 0      offset: 4128 
      Highwater::  0x02c000c3  ext#: 0      blk#: 1      ext size: 7    
  #blocks in seg. hdr's freelists: 1    
  #blocks below: 1    
  mapblk  0x00000000  offset: 0    
                   Unlocked
     Map Header:: next  0x00000000  #extents: 1    obj#: 31997  flag: 0x40000000
  Extent Map
  -----------------------------------------------------------------
   0x02c000c2  length: 7    
 
  nfl = 1, nfb = 1 typ = 1 nxf = 0 ccnt = 1
  SEG LST:: flg: USED   lhd: 0x02c000c2 ltl: 0x02c000c2
End dump data blocks tsn: 11 file#: 11 minblk 193 maxblk 193

--------------------next---------------------