ts_usage_graph

column tablespace format a20
column total_GB format 999,999,999,999.99
column used_GB format 999,999,999,999.99
column free_GB format 999,999,999.99
column pct_used format 999.99
column graph format a25 heading "GRAPH (X=5%)"
break on report
set lines 132 pages 50

select total.ts tablespace, total.GB total_GB, NVL(total.GB - free.GB,total.GB) used_GB, NVL(free.GB,0) free_GB, DECODE(total.GB,NULL,0,NVL(ROUND((total.GB - free.GB)/(total.GB)*100,2),100)) pct_used, CASE WHEN (total.GB IS NULL) THEN '['||RPAD(LPAD('OFFLINE',13,'-'),20,'-')||']' ELSE '['|| DECODE(free.GB, null,'XXXXXXXXXXXXXXXXXXXX', NVL(RPAD(LPAD('X',trunc((100-ROUND( (free.GB)/(total.GB) * 100, 2))/5),'X'),20,'-'), '
--------------------'))||']'
END as GRAPH
from
(select tablespace_name ts, sum(bytes)/1024/1024/1024 GB
from dba_data_files group by tablespace_name) total,
(select tablespace_name ts, sum(bytes)/1024/1024/1024 GB
from dba_free_space group by tablespace_name) free
where total.ts=free.ts(+) and NVL(ROUND((total.GB - free.GB)/(total.GB)*100,2),100) >=0 and total.ts not like '%UNDO%' order by 5;