一：LMT表空间测试
1：首先建立单独的LMT表空间以及用户
[oracle@www oracle]$ sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.8.0 - Production on Sat Oct 21 14:59:41 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
SQL> create tablespace hwm datafile '/free/oracle/oradata/orcl/hwm.dbf' size 10m;
IXDBA.NET社区论坛
Tablespace created.
SQL> create user hwm identified by hwm default tablespace hwm temporary tablespace temp;
User created.
SQL> grant connect,resource,dba to hwm;
Grant succeeded.
SQL> connect hwm/hwm
Connected.
SQL> create table hwm (id char(1000),name char(1000))
2 storage (minextents 2)
3 pctfree 50 pctused 20
4 /
Table created.
SQL> col OBJECT_NAME format a30
SQL>select object_id,object_name from dba_objects where object_name='HWM';
OBJECT_ID OBJECT_NAME
---------- ------------------------------
31787 HWM
SQL> select EXTENT_ID,FILE_ID,RELATIVE_FNO,BLOCK_ID,BLOCKS from dba_extents where segment_name='HWM';
EXTENT_ID FILE_ID RELATIVE_FNO BLOCK_ID BLOCKS
---------- ---------- ------------ ---------- ----------
0 11 11 9 128
1 11 11 137 128
SQL> alter system dump datafile 11 block 9; ＃dump出11号文件的第九块。
System altered.
2：查看11号文件的第九块信息：
[root@www udump]# more orcl_ora_11954.trc
下面的Highwater:: 0x02c0000a是HWM的初始位置。
Start dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
buffer tsn: 12 rdba: 0x02c00009 (11/9)
scn: 0x0000.000d62d4 seq: 0x01 flg: 0x00 tail: 0x62d41001
frmt: 0x02 chkval: 0x0000 type: 0x10=DATA SEGMENT HEADER - UNLIMITED
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 2 #blocks: 255
last map 0x00000000 #maps: 0 offset: 4128
Highwater:: 0x02c0000a ext#: 0 blk#: 0 ext size: 127
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 0
Unlocked
Map Header:: next 0x00000000 #extents: 2 obj#: 31787 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x02c0000a length: 127
0x02c00089 length: 128
nfl = 1, nfb = 1 typ = 1 nxf = 0 ccnt = 0
SEG LST:: flg: UNUSED lhd: 0x00000000 ltl: 0x00000000
End dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
3：插入数据，查看数据块信息：
首先插入一些数据：
SQL> insert into hwm values(2,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(3,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(4,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(5,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(6,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(7,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(8,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(9,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(9,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(8,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(6,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(7,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(6,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(4,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(11,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(12,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(13,'exitgogo');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(2,'exitgogo1');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(2,'exitgogo1');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(2,'exitgogo1');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
SQL> insert into hwm values(2,'exitgogo1');
1 row created.
SQL> commit;
Commit complete.
SQL> alter system dump datafile 11 block 9;
System altered.
4：插入一些数据后，然后查看dump跟踪数据块信息。
*** 2006-10-21 15:37:45.367
Start dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
buffer tsn: 12 rdba: 0x02c00009 (11/9)
scn: 0x0000.000d7d15 seq: 0x01 flg: 0x00 tail: 0x7d151001
frmt: 0x02 chkval: 0x0000 type: 0x10=DATA SEGMENT HEADER - UNLIMITED
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 2 #blocks: 255
last map 0x00000000 #maps: 0 offset: 4128
Highwater:: 0x02c0000b ext#: 0 blk#: 1 ext size: 127
#blocks in seg. hdr's freelists: 1
#blocks below: 1
mapblk 0x00000000 offset: 0
Unlocked
Map Header:: next 0x00000000 #extents: 2 obj#: 31787 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x02c0000a length: 127
0x02c00089 length: 128
nfl = 1, nfb = 1 typ = 1 nxf = 0 ccnt = 1
SEG LST:: flg: USED lhd: 0x02c0000a ltl: 0x02c0000a
End dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
*** 2006-10-21 15:38:55.552
Start dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
buffer tsn: 12 rdba: 0x02c00009 (11/9)
scn: 0x0000.000d7d15 seq: 0x01 flg: 0x00 tail: 0x7d151001
frmt: 0x02 chkval: 0x0000 type: 0x10=DATA SEGMENT HEADER - UNLIMITED
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 2 #blocks: 255
last map 0x00000000 #maps: 0 offset: 4128
Highwater:: 0x02c0000b ext#: 0 blk#: 1 ext size: 127
#blocks in seg. hdr's freelists: 1
#blocks below: 1
mapblk 0x00000000 offset: 0
Unlocked
Map Header:: next 0x00000000 #extents: 2 obj#: 31787 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x02c0000a length: 127
0x02c00089 length: 128
nfl = 1, nfb = 1 typ = 1 nxf = 0 ccnt = 1
SEG LST:: flg: USED lhd: 0x02c0000a ltl: 0x02c0000a
End dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
*** 2006-10-21 15:39:34.354
Start dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
buffer tsn: 12 rdba: 0x02c00009 (11/9)
scn: 0x0000.000d7ea4 seq: 0x02 flg: 0x00 tail: 0x7ea41002
frmt: 0x02 chkval: 0x0000 type: 0x10=DATA SEGMENT HEADER - UNLIMITED
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 2 #blocks: 255
last map 0x00000000 #maps: 0 offset: 4128
Highwater:: 0x02c0000c ext#: 0 blk#: 2 ext size: 127
#blocks in seg. hdr's freelists: 1
#blocks below: 2
mapblk 0x00000000 offset: 0
Unlocked
Map Header:: next 0x00000000 #extents: 2 obj#: 31787 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x02c0000a length: 127
0x02c00089 length: 128
nfl = 1, nfb = 1 typ = 1 nxf = 0 ccnt = 2
SEG LST:: flg: USED lhd: 0x02c0000b ltl: 0x02c0000b
End dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
*** 2006-10-21 15:40:11.630
Start dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
buffer tsn: 12 rdba: 0x02c00009 (11/9)
scn: 0x0000.000d7ea4 seq: 0x02 flg: 0x00 tail: 0x7ea41002
frmt: 0x02 chkval: 0x0000 type: 0x10=DATA SEGMENT HEADER - UNLIMITED
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 2 #blocks: 255
last map 0x00000000 #maps: 0 offset: 4128
Highwater:: 0x02c0000c ext#: 0 blk#: 2 ext size: 127
#blocks in seg. hdr's freelists: 1
#blocks below: 2
mapblk 0x00000000 offset: 0
Unlocked
Map Header:: next 0x00000000 #extents: 2 obj#: 31787 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x02c0000a length: 127
0x02c00089 length: 128
nfl = 1, nfb = 1 typ = 1 nxf = 0 ccnt = 2
SEG LST:: flg: USED lhd: 0x02c0000b ltl: 0x02c0000b
End dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
*** 2006-10-21 15:41:05.302
Start dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
buffer tsn: 12 rdba: 0x02c00009 (11/9)
scn: 0x0000.000d7fb9 seq: 0x02 flg: 0x00 tail: 0x7fb91002
frmt: 0x02 chkval: 0x0000 type: 0x10=DATA SEGMENT HEADER - UNLIMITED
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 2 #blocks: 255
last map 0x00000000 #maps: 0 offset: 4128
Highwater:: 0x02c0000d ext#: 0 blk#: 3 ext size: 127
#blocks in seg. hdr's freelists: 1
#blocks below: 3
mapblk 0x00000000 offset: 0
Unlocked
Map Header:: next 0x00000000 #extents: 2 obj#: 31787 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x02c0000a length: 127
0x02c00089 length: 128
nfl = 1, nfb = 1 typ = 1 nxf = 0 ccnt = 3
SEG LST:: flg: USED lhd: 0x02c0000c ltl: 0x02c0000c
End dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
*** 2006-10-21 15:41:35.802
Start dump data blocks tsn: 12 file#: 11 minblk 9 maxblk 9
buffer tsn: 12 rdba: 0x02c00009 (11/9)
scn: 0x0000.000d7fb9 seq: 0x02 flg: 0x00 tail: 0x7fb91002
frmt: 0x02 chkval: 0x0000 type: 0x10=DATA SEGMENT HEADER - UNLIMITED
Extent Control Header
-----------------------------------------------------------------
