Total Tablespace space usage – Scripts

Total Tablespace space usage – Scripts

select tbs.tbs,total_mb tbs_mb, nvl(free_mb,0) free_mb, round(nvl(free_mb,0)/total_mb*100,2) pct_free,

total_mb*25/100 -nvl(free_mb,0) Est_mb    from

(select tablespace_name tbs,round(sum(bytes)/1024/1024,2) free_mb

from dba_free_space   group by tablespace_name) free_tbs,

(select tablespace_name tbs,round(sum(bytes)/1024/1024,2) total_mb

from dba_data_files   group by tablespace_name) tbs

where tbs.tbs=free_tbs.tbs(+) AND round(nvl(free_mb,0)/total_mb*100,2)<=10;