ORACLE空间管理实验1：探索LMT表空间管理下数据文件头的结构及位图中区的记录方式 - 数据库编程

F0F00 0000000000000000

删除第一个表：
BYS@ bys3>truncate table test2;
Table truncated.
BYS@ bys3>alter system checkpoint;
System altered.
BYS@ bys3>exit
新会话：
BYS@ bys3>alter system dump datafile 7 block 3;
System altered.
BYS@ bys3>select value from v$diag_info where name like 'De%';
VALUE
----------------------------------------------------------------------------------------------------
/u01/diag/rdbms/bys3/bys3/trace/bys3_ora_22707.trc
此时DUMP文件中3号块的位图记录：
RelFno: 7, BeginBlock: 128, Flag: 0, First: 1, Free: 63451
0100000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 0000000000000000 000 0FFFFFFFF0F00 0000000000000000

3.不同大小的区分配方式，对位图中区的记录没有影响。

BYS@ bys3>create tablespace test3 datafile '/u01/oradata/bys3/test3.dbf' size 100m uniform size 8m;
Tablespace created.
BYS@ bys3>create table test33(aa int) tablespace test3;

Table created.
BYS@ bys3>insert into test33 values(11);
1 row created.
BYS@ bys3>commit;
Commit complete.
BYS@ bys3>alter system checkpoint;
System altered.
BYS@ bys3>alter system dump datafile 8 block 3;
System altered.
BYS@ bys3>select * from v$DIAG_INFO;
/u01/diag/rdbms/bys3/bys3/trace/bys3_ora_23058.trc
###########
RelFno: 8, BeginBlock: 128, Flag: 0, First: 1, Free: 63487
0100000000000000 0000000000000000 0000000000000000 0000000000000000
########33
BYS@ bys3>alter table test33 allocate extent;
Table altered.
BYS@ bys3>alter system checkpoint;
System altered.
BYS@ bys3>alter system dump datafile 8 block 3;
#############3
RelFno: 8, BeginBlock: 128, Flag: 0, First: 2, Free: 63486
0300000000000000 --这里的十六进制3，转换为二进制就是11，表示分配了两个区。

ORACLE空间管理实验1：探索LMT表空间管理下数据文件头的结构及位图中区的记录方式(三)

3.不同大小的区分配方式，对位图中区的记录没有影响。