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