oracle 9i 行头带有scn的表

oracle 9i 行头带有scn的表

conn scott/tiger
drop table t1;
drop table t2;
create table t1(c varchar2(5));
create table t2(c varchar2(6)) ROWDEPENDENCIES;
--t2表每行都有scn,会增加六个字节的开销

alter table t1 pctfree 0;
alter table t2 pctfree 0;

insert into t1 values('asdfg');
insert into t2 values('asdfg');

insert into t1 select * from t1;
/
/

insert into t2 select * from t2;
/
/
/

select dbms_rowid.rowid_block_number(rowid) block#,count(*) 
from t1 group by dbms_rowid.rowid_block_number(rowid);
BLOCK#   COUNT(*)
------ ----------
    68        733
    69        733

select dbms_rowid.rowid_block_number(rowid) block#,count(*) 
from t2 group by dbms_rowid.rowid_block_number(rowid);

 BLOCK#   COUNT(*)
------- ----------
     76        474
     77        474