set pagesize 1000
col mb form 9,999

select tablespace_name, sum(bytes)/1024/1024 mb, count(*) from dba_data_files
where file_name like '&file_name' group by tablespace_name
/