SQL> select num_rows,blocks,empty_blocks,avg_space,LAST_ANALYZED from user_tables where table_name='T';
NUM_ROWS BLOCKS EMPTY_BLOCKSAVG_SPACE LAST_ANALY
---------- ---------- ------------ ---------- ----------
23497327
0
0 05-4ÔÂ -06
SQL> truncate table t;
±íÒѽصô¡£
SQL> select num_rows,blocks,empty_blocks,avg_space,LAST_ANALYZED from user_tables where table_name='
T';
NUM_ROWS BLOCKS EMPTY_BLOCKSAVG_SPACE LAST_ANALY
---------- ---------- ------------ ---------- ----------
23497327
0
0 05-4ÔÂ -06
SQL> exec dbms_stats.gather_table_stats('xxx','t');
PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
SQL> select num_rows,blocks,empty_blocks,avg_space,LAST_ANALYZED from user_tables where table_name='
T';
NUM_ROWS BLOCKS EMPTY_BLOCKSAVG_SPACE LAST_ANALY
---------- ---------- ------------ ---------- ----------
0
0
0
0 06-4ÔÂ -06
感谢biti和几位达人。是我记错了。我查了一下文档,类似的存储统计信息的表有dba_tables,dba_indexes,dba_tab_columns几大类. |