分析数据高水位

ANALYZE TABLE BASEINFO COMPUTE  STATISTICS;

select * from organizations;

SELECT blocks, empty_blocks, num_rows

FROM user_tables

WHERE table_name = 'BASEINFO';


alter table BASEINFO enable row movement
alter table BASEINFO shrink space cascade;
alter table BASEINFO disable row movement;