Help! What is wrong with this query

Hello
I can't seem to get correct values for some of the tablespace with this query.

select o.tablespace_name, round(sum(o.bytes/(1024 * 1024)),2) "Total(MB)", round(sum(u.bytes/(1024 *1024)),2) "FreeMB" from dba_data_files o, dba_free_space u
where o.tablespace_name = u.tablespace_name group by o.tablespace_name;

thanks
Sunit Received on Tue Mar 26 2002 - 09:07:49 CST