查看oracle中表空间使用率(包含临时表空间)

select *
  from (Select a.tablespace_name as "表空间名",
               (a.bytes - b.bytes) "表空间使用大小(BYTE)",
               a.bytes / (1024 * 1024 * 1024) "表空间大小(GB)",
               b.bytes / (1024 * 1024 * 1024) "表空间剩余大小(GB)",
               (a.bytes - b.bytes) / (1024 * 1024 * 1024) "表空间使用大小(GB)",
               to_char((1 - b.bytes / a.bytes) * 100, '99.99999') || '%' "使用率"
          from (select tablespace_name, sum(bytes) bytes
                  from dba_data_files
                 group by tablespace_name) a,
               (select tablespace_name, sum(bytes) bytes
                  from dba_free_space
                 group by tablespace_name) b
         where a.tablespace_name = b.tablespace_name
        union all
        select c.tablespace_name,
               d.bytes_used "表空间使用大小(BYTE)",
               c.bytes / (1024 * 1024 * 1024) "表空间大小(GB)",
               (c.bytes - d.bytes_used) / (1024 * 1024 * 1024) "表空间剩余大小(GB)",
               d.bytes_used / (1024 * 1024 * 1024) "表空间使用大小(GB)",
               to_char(d.bytes_used * 100 / c.bytes, '99.99999') || '%' "使用率"
          from (select tablespace_name, sum(bytes) bytes
                  from dba_temp_files
                 group by tablespace_name) c,
               (select tablespace_name, sum(bytes_cached) bytes_used
                  from v$temp_extent_pool
                 group by tablespace_name) d
         where c.tablespace_name = d.tablespace_name)
 order by 表空间名;