可以通过查询dba_extents 计算某个表已经用了多大空间
查询之前之前,要进行analyze ,
如 analyze table serapy compute statistics;
查询语句:
SELECT owner,table_name,
NUM_ROWS,
BLOCKS*AAA/1024/1024 "Size M",
EMPTY_BLOCKS,
LAST_ANALYZED
FROM dba_tables
where table_name='SERAPY';
其中serapy为表名,AAA为db_block_size大小
如:
SELECT owner,table_name,
NUM_ROWS,
BLOCKS*8912/1024/1024 "Size M",
EMPTY_BLOCKS,
LAST_ANALYZED
FROM dba_tables
Where table_name='EMP'
I am serapy ! 转载注明:
http://blog.sina.com.cn/s/blog_8c6d7ff60100vdlj.html