常用Oracle DBA查询(二)
sum(bytes/1024/1024) Free_Space
from sys.dba_free_space
group by tablespace_name
) Free,
(select b.name, sum(bytes/1024/1024) total_space
from sys.v_$datafile a, sys.v_$tablespace B
where a.ts# = b.ts#
group by b.name
) T
WHERE Free.Tablespace_name = T.name
-- -------------------------------------------------------------------
作者 yoyudenghihi