1)select tablespace_name,count(*),max(blocks),sum(blocks) from dba_free_space group by tablespace_name; 2)可以通过连接查找dba_tablespaces和dba_extents表得到每个表空间中有多少存储空间被使用, select a.tablespace_name,nvl(count(extent_id),0) extents,sum(nvl(bytes,0)) bytes_used, sum(nvl(blocks,0)) blocks_used from dba_tablespace a,dba_extents b where a.tablespace_name=b.tablespace_name(+) group by a.tablespace_name; 试下这个吧
from dba_free_space
group by tablespace_name;
2)可以通过连接查找dba_tablespaces和dba_extents表得到每个表空间中有多少存储空间被使用,
select a.tablespace_name,nvl(count(extent_id),0) extents,sum(nvl(bytes,0)) bytes_used,
sum(nvl(blocks,0)) blocks_used
from dba_tablespace a,dba_extents b
where a.tablespace_name=b.tablespace_name(+)
group by a.tablespace_name;
试下这个吧