Oracle table and number of blocks
Assuming there are no LOB fields or other specialties:

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