Ed Heal

Asked: 2015-07-20 06:06:52 +0800 CST2015-07-20 06:06:52 +0800 CST 2015-07-20 06:06:52 +0800 CST

Oracle表和块数

找出表（oracle）占用的块数和范围数的最简单方法是什么？

Best Answer

Balazs Papp

假设没有 LOB 字段或其他专业：

select sum(blocks) as blocks, count(*) as extents 
from dba_extents
where owner = '&table_owner' and segment_name = '&table_name';

相关问题