如何查看表占用空间情况?

SQL> analyze table emp1 compute statistics;

Table analyzed.

SQL> select table_name,blocks from user_tables;

TABLE_NAME                         BLOCKS
------------------------------ ----------
EMP3                                  499
EMP1                                  338
T                                       5
LIST1                                   0
COMPOSITE1                              0
RANGE2                               1256
RANGE1                                300
EMP                                   120

8 rows selected.

 

posted @ 2013-06-08 22:01  ArcerZhang  阅读(164)  评论(0编辑  收藏  举报