Re: Tablespace free space evaluation

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 17 Apr 2001 10:28:23 +0200
Message-ID: <9bgur8$2fe$1@s1.read.news.oleane.net>

"Jean Buchet" <jbuchet_at_auchan.com> a écrit dans le message news: 9bgtgc$qjj$1_at_reader1.imaginet.fr...
> Hi!
>
> How can I evaluate a tablespace free space, using only SQL/PLSQL?
>
> Thanks
>
> Jean
>
>
>
>

You can query dba_free_space.

For instance:
select ts.tablespace_name tablespace,

       to_char(ts.bytes / 1024 / 1024,'999999990') size_mo,
       to_char(nvl(sum(fs.bytes)/1024/1024, 0),'999999990') free_mo,
       to_char(nvl(sum(fs.bytes), 0) / ts.bytes * 100, '990.0') pct_free
from dba_free_space fs,
     (select tablespace_name, sum(bytes) bytes
      from dba_data_files
      group by tablespace_name) ts

where fs.tablespace_name (+) = ts.tablespace_name group by ts.tablespace_name, ts.bytes
/

--
Regards
Michel

Received on Tue Apr 17 2001 - 03:28:23 CDT