--整理表碎片
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