1:执行如下脚本:
begindbms_utility.analyze_schema("SCOTT","COMPUTE");end;
2:得到分析结果:
select t.table_name,t.num_rows,t.blocks,t.empty_blocksfrom user_tables t;