【ORACLE】碎片整理

alter table test enable row movement;

alter table test shrink space;

execute dbms_stats.gather_table_stats(ownname=>'&owner',tabname=>'&table_name', estimate_percent=>null,method_opt=>'for all columns' ,degree=>2,cascade=>true);