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
where
   df.tablespace_name = fs.tablespace_name (+)
/
clear compute
clear break
clear column


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

Other related posts: