Particular Tablespace Usage Report:

Particular Tablespace Usage Report:

select tablespace_name, tbs_mb, free_mb,

round(free_mb/tbs_mb*100,2) pct_free, round(tbs_mb*15/100-free_mb,2) Est_mb from

( select a.tablespace_name ,sum(bytes)/1024/1024 tbs_mb,

nvl((select sum(bytes)/1024/1024 from dba_free_space where tablespace_name=a.tablespace_name),0) free_mb

from dba_data_files a group by tablespace_name)

where free_mb/tbs_mb*100 <=10 and tablespace_name ='&tablespace_name';