Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: sufficient next extent space

Re: sufficient next extent space

From: <Tony.Adolph_at_o2.com>
Date: Mon, 7 Feb 2005 14:05:21 +0100
Message-ID: <OF17F73077.76BD596D-ONC1256FA1.0047BCFD-C1256FA1.0047C87B@viaginterkom.de>


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
Received on Mon Feb 07 2005 - 08:05:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US