dba_tables和dba_segments里记录的表大小的比较

  11G数据库，以scott用户所拥有的表为例

--1.先查看这两个表
SQL> select table_name, num_rows, avg_row_len, blocks, blocks from dba_tables where owner='SCOTT';
 
TABLE_NAME        NUM_ROWS AVG_ROW_LEN     BLOCKS     BLOCKS
--------------- ---------- ----------- ---------- ----------
DEPT                     4          20          5          5
EMP                     14          38          5          5
SALGRADE                 5          10          5          5
BONUS                    0           0          0          0   --这个表里面没有记录，dba_tables记下了这个表
 
SQL> select segment_name, blocks, bytes from dba_segments where owner='SCOTT' and segment_type='TABLE';
 
SEGMENT_NAME        BLOCKS      BYTES
--------------- ---------- ----------
DEPT                     8      65536
EMP                      8      65536
SALGRADE                 8      65536
                                             --BONUS表没记录ÿ