RE: Free space for all tablespaces

Thanks for the reply but... I have tried this. For some reason that I don't understand it seems to fail when the tablespace has more than 1 datafile. It does not generate an error - it just gives the wrong answer - really weird.

thanks anyway,

..tom

> -----Original Message-----
> From: Suhen Pather [SMTP:pathers5_at_telkom.co.za]
> Sent: Tuesday, July 11, 2000 10:58 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Free space for all tablespaces
>
> You can try this it works
>
> select a.tablespace_name, sum(a.bytes/1024/1024) "Allocated" ,
> sum(b.bytes/1024/1024) "Free Space" from sys.dba_data_files a,
> sys.dba_free_space b
> where a.tablespace_name = b.tablespace_name
> group by a.tablespace_name
> /
>
> Regards
> $uhen
> Oracle DBA
> Telkom SA
>
>
> >>> blair_at_pjm.com 07/11/00 03:56PM >>>
> I just want a SQL query to give me the freespace in all tablespaces. This
> doesn't work:
>
> select a.tablespace_name, sum(a.bytes) TOTAL_SPACE, sum(b.bytes)a FREE_SPACE
> from sys.dba_data_files a, sys.dba_free_space b
> where a.tablespace_name = b.tablespace_name
> group by 1;
>
> Does anyone have a query that does work??
>
> thanks,
>
> ..tom
>
>
>
> --
> Author:
> INET: blair_at_pjm.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).
>
> --
> Author: Suhen Pather
> INET: pathers5_at_telkom.co.za
>
> 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
Received on Tue Jul 11 2000 - 09:44:08 CDT