计算一个表占用的空间的大小

select owner,table_name,
NUM_ROWS,
BLOCKS*AAA/1024/1024 "Size M",
EMPTY_BLOCKS,
LAST_ANALYZED
from dba_tables
where table_name='XXX';

Here: AAA is the value of db_block_size ;
XXX is the table name you want to check

[@more@]select owner,table_name,
NUM_ROWS,
BLOCKS*AAA/1024/1024 "Size M",
EMPTY_BLOCKS,
LAST_ANALYZED
from dba_tables
where table_name='XXX';

Here: AAA is the value of db_block_size ;
XXX is the table name you want to check

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/1724534/viewspace-884773/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/1724534/viewspace-884773/