Re: Tablespace

Jeff

Thanks a lot, that's what I was looking for.

Witold

On 30 Oct 2000, at 10:15, Jeff Landers wrote:

> 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(+);
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeff Landers
> INET: jlanders_at_convergys.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).
Received on Mon Oct 30 2000 - 12:38:24 CST