表空间使用情况查询
select * from dba_tablespaces;
Select * From dba_data_files;
Select * From dba_free_space;
Select m.tablespace_name,
s1.filecount,
s1.total,
s1.extended,
s2.free,
s1.total - s1.extended + s2.free remain,
concat(round((s1.total - s1.extended + s2.free) * 100 / s1.total, 2),
'%') ratio2
From dba_tablespaces m
Inner Join (Select tablespace_name,
Count(Distinct file_name) filecount,
round(Sum(maxbytes) / (1024 * 1024), 2) total,
round(Sum(bytes) / (1024 * 1024), 2) extended
From dba_data_files
Group By tablespace_name) s1
On m.tablespace_name = s1.tablespace_name
Inner Join (Select tablespace_name,
round(Sum(bytes) / (1024 * 1024), 2) free
From dba_free_space
Group By tablespace_name) s2
On m.tablespace_name = s2.tablespace_name
Order By 3 Desc;