col FILE_NAME for a60 set pagesize 250 set linesize 80 column Pourcentage format 999.99 heading "Pourcentage" spool &1 set termout off SELECT DISTINCT DDF.file_name, round((round((DDF.bytes/1024/1024)-(sum(DFS.bytes)/1024/1024),2))*100/(DDF.maxbytes/1024/1024),2) 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;