自己写的关于oracle表空间的统计

权限要求：
1、resource, dba

 --查看所有表空间的使用情况
select a.tablespace_name 表空间,
       a.total_bytes || 'M' 总计,
       a.total_bytes - nvl(b.free_bytes, 0) || 'M' 已使用,
       round((a.total_bytes - nvl(b.free_bytes, 0)) / a.total_bytes, 4) * 100 || '%' 已使用百分比,
       nvl(b.free_bytes, 0) || 'M' 剩余,
       round(nvl(b.free_bytes, 0) / a.total_bytes, 4) * 100 || '%' 剩余百分比
  from (select df.tablespace_name, sum(df.bytes) / 1024 / 1024 Total_bytes
          from dba_data_files df
         group by df.tablespace_name) a,
       (select fs.tablespace_name, sum(fs.bytes) / 1024 / 1024 Free_bytes
          from dba_free_space fs
         group by fs.tablespace_name) b
 where a.tablespace_name = b.tablespace_name(+)
 order by a.total_bytes desc