--查看表空间使用情况
select t1 "表空间" ,z/(1024*1024*1024) "总表空间",
z-s/(1024*1024*1024) "已用表空间",
s/(1024*1024*1024) "剩余表空间",
ROUND((z-s)/z*100,2) "使用率%"
from (select tablespace_name t1, sum(bytes) s
from dba_free_space group by tablespace_name),
(select tablespace_name t2, sum(bytes) z
from dba_data_files
group by