set pages 999;
column file_name format a65;
column file_id format 999;
column tablespace_name format a20;
column bytes format 999999999.99 heading "BYTES|(MBytes)";
column status format a12;
column maxbytes format 999999999.99 heading "MAXBYTES|(MBytes)";
column user_bytes format 999999999.99 heading "USER_BYTES|(MBytes)";
select file_name
     , file_id
	 , tablespace_name
	 , bytes/1024/1024 bytes
	 , status
	 , maxbytes/1024/1024 maxbytes
	 , user_bytes/1024/1024 user_bytes
from dba_data_files
order by tablespace_name;