–查看t2表行数据库分布 select id,dbms_rowid.rowid_relative_fno(rowid)||_||dbms_rowid.rowid_block_number(rowid) location from t2 order by location,id; –索引统计收集 exec dbms_stats.gather_table_stats(ownname=SYS