Oracle表空间查看sql使用情况

select a.tablespace_name tablespace_name,nvl(ceil((1 - b.free / a.total) * 100), 100) "usage_of_tablespace%",nvl(b.free, 0) "left_space(M)",c.extent_management "Extent_management"from (select tablespace_name, sum(nvl(bytes, 0)) / 1024 / 1024 totalfrom dba_data_filesgroup by tablespace_name) a,(select tablespace_name, sum(nvl(bytes, 0)) / 1024 / 1024 freefrom dba_free_spacegroup by tablespace_name) b,dba_tablespaces cwhere a.tablespace_name = c.tablespace_nameand c.tablespace_name = b.tablespace_name(+);