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 /