Re: Tablespace

Witold Iwaniec wrote:

> Hi all
>
> How could I find how much space is used and how much is still
> free in a tablespace? (Oracle 8.1.6)
>
> Thanks
>
> Witold
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Witold Iwaniec
> INET: wiwaniec_at_novalistech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

  Hi Witold

Try this:

column total_space format 999,999,999,999 column free_space format 999,999,999,999 column pct_free format 999.99

select a.tablespace_name,

        total_space,
        free_space,
        free_space/total_space*100 pct_free
from (select tablespace_name, sum(bytes) total_space from dba_data_files
        group by tablespace_name) a,
        (select tablespace_name, sum(bytes) free_space from
dba_free_space
        group by tablespace_name) b
        where a.tablespace_name = b.tablespace_name(+);