Cheeky Cockatoo

select f.file_name, max(e.block_id+e.blocks)*8192/1024/1024
from dba_data_files f, dba_extents e
where e.file_id = f.file_id
and e.tablespace_name = '&tspace_name'
group by f.file_name;