所属类别：开发技术

文章作者：asmboy001

特别推荐：免费发布信息 承包关键词~~抢爆了！^HOT!

create table t nologgingasselect o.* from(select * from dba_objects where rownum <10001) o,(select * from dba_objects where rownum <101) o2order by o.object_id;select bytes/1024/1024 from user_segments where segment_name='T';T大小为104Mselect count(*) from t;delete from t where mod(object_id,2)=0;commit;select count(*) from t;alter table t enable row movement;select a.name,b.valuefrom v$statname a,v$mystat bwhere a.statistic#=b.statistic# and a.name='redo size';shrink之前redo size 173Malter table t shrink space;select a.name,b.valuefrom v$statname a,v$mystat bwhere a.statistic#=b.statistic# and a.name='redo size';shrink之后 redo size 356Mselect bytes/1024/1024 from user_segments where segment_name='T';46M分析tableanalyze table TBLMINNO compute statistics;select table_name,num_rows,AVG_ROW_LEN,BLOCKS,EMPTY_BLOCKS from dba_tableswhere table_name='TBLMINNO';本文出自 51CTO.COM技术博客

....