oracle 10g中查看表空间和表空间信息

select df.tablespace_name "TABLESPACE_NAME",       totalspace "TOTALSPACE/M",       freespace "FREESPACE/M",       round((1 - freespace / totalspace) * 100, 2) "USED%"  from (select tablespace_name, round(sum(bytes) / 1024 / 1024) totalspace          from dba_data_files         group by tablespace_name) df,       (select tablespace_name, round(sum(bytes) / 1024 / 1024) freespace          from dba_free_space         group by tablespace_name) fs where df.tablespace_name = fs.tablespace_name;