Re: HELP: need % of tablespace free

jul395_at_prb.mhs.compuserve.com (Jonathan Julian) wrote:

>I need to know what percentage of a tablespace is filled with data. I
>had hoped it was a simple query in SQL, like
 

>select TOTAL, FREE from USER_TABLESPACE
>where NAME ='tabelspace_name';

Should be something like:

select df.tablespace_name Tablespace,

        sum(fs.bytes)*100/sum(df.bytes) Free  from sys.dba_data_files df,

        sys.dba_free_space fs
 where df.tablespace_name = fs.tablespace_name  group by df.tablespace_name,fs.tablespace_name;

>Jonathan Julian
>PRB Associates, Inc.
>jul395_at_prb.mhs.compuserve.com

Standard disclaimers apply Received on Wed Feb 14 1996 - 00:00:00 CET