Check DB Usage per tablespace .....
select
a.tablespace_name, round(a.bytes/1024/1024/1024,2) Total,
round( nvl( b.bytes,0)/1024/1024/1024,2) Used,
round(nvl(c.bytes, 0)/1024/1024/1024,2) Free ,
round(nvl(b.bytes,0)*100/nvl(a.bytes,0),2) "% Used"
from sys.sm$ts_avail a, sys.sm$ts_used b, sys.sm$ts_free c
where a.tablespace_name=b.tablespace_name(+)
and b.tablespace_name=c.tablespace_name(+)
order by round(nvl(b.bytes,0)*100/nvl(a.bytes,0),2) desc;
a.tablespace_name, round(a.bytes/1024/1024/1024,2) Total,
round( nvl( b.bytes,0)/1024/1024/1024,2) Used,
round(nvl(c.bytes, 0)/1024/1024/1024,2) Free ,
round(nvl(b.bytes,0)*100/nvl(a.bytes,0),2) "% Used"
from sys.sm$ts_avail a, sys.sm$ts_used b, sys.sm$ts_free c
where a.tablespace_name=b.tablespace_name(+)
and b.tablespace_name=c.tablespace_name(+)
order by round(nvl(b.bytes,0)*100/nvl(a.bytes,0),2) desc;
Labels: Oracle
for this post
Leave a Reply