Show Used/free space in Meg by tablespace name

DBA FUS‎ > ‎

posted Sep 11, 2010, 5:29 AM by Sachchida Ojha

SELECT Total.name "Tablespace Name",

nvl(Free_space, 0) Free_space,

nvl(total_space-Free_space, 0) Used_space,

total_space

FROM

(select tablespace_name, 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

) Total

WHERE Free.Tablespace_name(+) = Total.name

ORDER BY Total.name

Comments