set pagesize 1000 set linesize 132 set heading off set feedback off col file_name form a65 col ts form a12 col mb form 9,999 select tablespace_name ts, file_name, bytes/1024/1024 mb from dba_data_files order by file_id / set heading on set feedback on