oracle 对于大表的整理，索引，统计的整理

 

--整理表碎片
select 'alter table '||table_name||' enable row movement;
alter table '||table_name||'  shrink space cascade;
alter table '||table_name||' disable row movement;'
from user_tables order by table_name;

select 'alter index '||index_name||'  shrink space cascade;'
from user_indexes  order by index_name;

select 'alter index '||index_name ||' rebuild online;
commit;' from user_indexes
order by index_name;

SELECT 'analyze table '||TABLE_NAME||' compute statistics;'
FROM USER_TABLES
ORDER BY TABLE_NAME