Re: sufficient next extent space

compute sum of total_MB on report
compute sum of used_MB on report
compute sum of free_MB on report
break on report
column ts format a15 heading "Tablespace|* = auto extend" column TOTAL_MB format 9,999,999 heading "Size|Mbytes" column pct_free format 999.99 heading "% Free" column pct_used format 999.99 heading "% Used" column used_MB format 9,999,999.9 heading "Used|Mbytes" column free_MB format 9,999,999.9 heading "Free|Mbytes" column max_extent_size format 99,999.99 heading "Largest|free|extent|Mbytes"

select

        df.tablespace_name||decode(autoextensible,'YES','*',' ') ts,
        total/1024/1024 Total_MB,


        (total - free)/1024/1024 Used_MB,

        ((total - free)/ total) * 100 pct_used,

        free/1024/1024 free_MB,


        (free / total ) * 100 pct_free,

        max_extent/1024/1024 max_extent_size
from


        (select

                tablespace_name,
                sum(bytes) free,
                max(bytes) max_extent
        from
                dba_free_space
        group
                by tablespace_name) fs
,


        (select

                tablespace_name,
                autoextensible,
                sum(bytes) total
        from
                dba_data_files
        group by tablespace_name, autoextensible
        union all
        select
                tablespace_name,
                autoextensible,
                sum(bytes) total
        from
                dba_temp_files
        group by tablespace_name,autoextensible) df

   df.tablespace_name = fs.tablespace_name (+) /
clear compute
clear break
clear column

--
http://www.freelists.org/webpage/oracle-l