--表空间使用
select tablespace_name, sum(bytes / 1024 / 1024) || ' MB' as Used_MB
from dba_segments
where segment_name not like 'BIN$%'
group by tablespace_name; --直接查各表空间使用空间
select total.tablespace_name,
total.filebytes / 1024 / 1024 || ' MB' as "File_Bytes_MB",
total.bytes / 1024 / 1024 || ' MB' "Total_MB",
(total.bytes - free.bytes) / 1024 / 1024 || ' MB' "Used_MB",
free.bytes / 1024 / 1024 || ' MB' "Free_MB",
round(((total.bytes - free.bytes) / total.bytes) * 100, 2) || '%' "Percent_Used"
from (select tablespace_name, sum(bytes) filebytes, sum(user_bytes) bytes
from dba_data_files
group by tablespace_name) total,
(select tablespace_name, sum(bytes) bytes
from dba_free_space
gro