Linux下查询表空间： select tablespace_name, ct, fr, bfb from (select a.tablespace_name, a.ct, b.fr, replace(to_char((a.ct - b.fr) / a.ct * 100, 9990.99), ' ') || '%' bfb from (select tablespace_name, sum(bytes) / 1024 / 1024 / 1024 as ct from dba_data_files group by tablespace_name) a, (select tablespace_name, sum(bytes) / 1024 / 1024 / 1024 as fr from dba_free_space group by tablespace_name) b where a.tablespace_name = b.tablespace_name union all select tablespace_name, sum(bytes_used) / 1024 / 1024 / 1024, sum(bytes_free) / 1024 / 1024 / 1024, replace(to_char(sum(bytes_used) / sum(bytes_used + bytes_free) * 100, 9990.99), ' ') from V$TEMP_SPACE_HEADER group by tablespace_name) order by tablespace_name;