See the table space usage
Posted on 2009-11-03 filed under: Oracle (RSS) 19 views
round (a.total_size)-round (nvl (b.free_size, 0), 1) "used (M)",
round (nvl (b.free_size, 0), 1) "free (M)",
round (nvl (b.free_size, 0) / total_size * 100,1) "free rate (%)"
from (select tablespace_name, sum (bytes) / 1024/1024 total_size
from dba_data_files
group by tablespace_name) a,
(select tablespace_name, sum (bytes) / 1024/1024 free_size
from dba_free_space
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name (+)
order by "free rate (%)";
Tags: table space, free space, space group, space usage