Friday 3 January 2014

Simple query to check Database growth in GB with respect to time---
-------------------------------------------------------------------------------------
select to_char(Trunc(creation_time,'MM'), 'MON RRRR') "Month",
sum(bytes)/1024/1024/1024 "Growth in GB"
from sys.v_$datafile
where creation_time > SYSDATE-9999
group by Trunc(creation_time,'MM')
order by Trunc(creation_time,'MM');

No comments:

Post a Comment