SELECT
       file_name,
       file_id,
       bytes/(1024*1024) Meigas,
       decode(maxbytes,0,'',to_char(maxbytes/(1024*1024),'999G999')) MaxMeigas,
       decode(maxblocks,0,'',to_char(increment_by*(maxbytes/maxblocks)/(1024*1024),'999G999')) Increm,
       status
FROM sys.dba_data_files
where tablespace_name like '%'||UPPER('&1')||'%'
 ORDER BY 1

/
