SQL> select count(*) from TESTSIZE;
COUNT(*)
----------
584576
SQL> select table_name,blocks,empty_blocks from dba_tables where owner='HXG';
TABLE_NAME BLOCKS EMPTY_BLOCKS
------------------------------ ---------- ------------
TESTSIZE
SQL>
BLOCKS,EMPTY_BLOCKS居然都是空值!
SQL> select segment_name,blocks from dba_segments where owner='HXG';
SEGMENT_NAME
--------------------------------------------------------------------------------
BLOCKS
----------
TESTSIZE
8064
SQL>analyze table TESTSIZE compute statistics;
SQL> select segment_name,blocks from dba_segments where owner='HXG';
SEGMENT_NAME
--------------------------------------------------------------------------------
BLOCKS
----------
TESTSIZE
8064
SQL> select table_name,blocks,empty_blocks from dba_tables where owner='HXG';
TABLE_NAME BLOCKS EMPTY_BLOCKS
------------------------------ ---------- ------------
TESTSIZE 7873 191
7873 + 191 = 8064