Oracle table and number of blocks What is the easiest way of finding out the number of blocks a table (oracle) occupies and the number of extents?
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';