col FILE_NAME for a60
set pagesize 250
set linesize 80
spool &1
set termout off
SELECT DISTINCT DDF.file_name,
To_char(round((round((DDF.bytes/1024/1024)-(sum(DFS.bytes)/1024/1024),2))*100/(DDF.maxbytes/1024/1024),2),'000D00')  Pourcentage
FROM  dba_free_space DFS, DBA_DATA_FILES DDF
where DDF.tablespace_name='&2'
and DDF.file_id=DFS.file_id
and DDF.autoextensible='YES'
group by DDF.file_name,DDF.bytes,DDF.user_bytes,DDF.maxbytes 
order by ddf.file_name desc;
set termout on
spool off
exit;

