SQL> execute dbms_stats.create_stat_table('ocp007','stat_table','users');
PL/SQL 过程已成功完成。
SQL> execute dbms_stats.export_table_stats('ocp007','EMPLOYEES',null,'stat_table','mytest',true,null);
PL/SQL 过程已成功完成。
SQL> select table_name,num_rows,blocks,empty_blocks,avg_space,avg_row_len,sample_size
2 from user_tables
3 where table_name='EMPLOYEES';
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE AVG_ROW_LEN SAMPLE_SIZE
------------------------------------------------------------ ---------- ---------- ------------ ----
EMPLOYEES 107 5 3 6249 82 107
SQL> analyze table employees delete statistics;
表已分析。
SQL> select table_name,num_rows,blocks,empty_blocks,avg_space,avg_row_len,sample_size
2 from user_tables
3 where table_name='EMPLOYEES';
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE AVG_ROW_LEN SAMPLE_SIZE
------------------------------------------------------------ ---------- ---------- ------------ ----
EMPLOYEES
SQL> execute dbms_stats.import_table_stats('ocp007','EMPLOYEES',null,'stat_table','mytest',true,null,false);
PL/SQL 过程已成功完成。
SQL> select table_name,num_rows,blocks,empty_blocks,avg_space,avg_row_len,sample_size
2 from user_tables
3 where table_name='EMPLOYEES';
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE AVG_ROW_LEN SAMPLE_SIZE
------------------------------------------------------------ ---------- ---------- ------------ ----
EMPLOYEES 107 5 0 0 82 107
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/95429/viewspace-269151/ ，如需转载，请注明出处，否则将追究法律责任。
