oracle 表大小最直接是通过block * db block size
db block size 可以通过 show parameter db_block_size; 取得
然后通过如下sql查询
select owner,
table_name,
NUM_ROWS,
BLOCKS * db_block_size/ 1024 / 1024 "Size M",
EMPTY_BLOCKS,
LAST_ANALYZED
from dba_tables;
oracle 表大小最直接是通过block * db block size
db block size 可以通过 show parameter db_block_size; 取得
然后通过如下sql查询
select owner,
table_name,
NUM_ROWS,
BLOCKS * db_block_size/ 1024 / 1024 "Size M",
EMPTY_BLOCKS,
LAST_ANALYZED
from dba_tables;
转载于:https://www.cnblogs.com/alex-blog/articles/3105503.html