Query to check Tablespace Size Free Space Used Space.

Query to check Table-space Size, Free Space ,Used Space.

Select
t.tablespace,
t.totalspace as ” Totalspace(MB)”,
round((t.totalspace-fs.freespace),2) as “Used Space(MB)”,
fs.freespace as “Freespace(MB)”,
round(((t.totalspace-fs.freespace)/t.totalspace)*100,2) as “% Used”,
round((fs.freespace/t.totalspace)*100,2) as “% Free”
from
(select round(sum(d.bytes)/(1024*1024)) as totalspace,
d.tablespace_name tablespace from dba_data_files d group by d.tablespace_name) t,
(select round(sum(f.bytes)/(1024*1024)) as freespace,
f.tablespace_name tablespace from dba_free_space f group by f.tablespace_name) fs
where
t.tablespace=fs.tablespace order by t.tablespace;