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表没记录ÿ