17,382
社区成员




create table tbl as select * from dba_objects;
analyze table tbl compute statistics;
select t.blocks,t.empty_blocks from user_tables t where t.table_name='TBL';
delete from tbl where rownum<10000;
alter table tbl deallocate unused;
analyze table tbl compute statistics;
select t.blocks,t.empty_blocks from user_tables t where t.table_name='TBL';
alter table tbl allocate extent (size 1m instance 1);
analyze table tbl compute statistics;
select t.blocks,t.empty_blocks from user_tables t where t.table_name='TBL';
alter table tbl deallocate unused;
analyze table tbl compute statistics;
select t.blocks,t.empty_blocks from user_tables t where t.table_name='TBL';