Today we are going to have look at the Database growth. With the help of the given query. DBA can find the monthly growth of there database. Sometimes little information is too much useful.




select to_char(CREATION_TIME,'RRRR') year, to_char(CREATION_TIME,'MM') month, round(sum(bytes)/1024/1024/1024) GB
from   v$datafile
group by  to_char(CREATION_TIME,'RRRR'),   to_char(CREATION_TIME,'MM')
order by   1, 2;


YEAR MO              GB
---- -- ---------------
2011 0              75
2012 6            4578
2012 7             334
2012 8             525
2012 9             659

About The Author


  1. Jasdeep Kaur

    select min(creation_time) “Create Time”,, round(sum(df.bytes)/1024/1024) curr_size_mb,
    round( (sum(df.bytes)/1024/1024)/round(sysdate-min(creation_time)),1) growth_per_day,
    round( (sum(df.bytes)/1024/1024)/round(sysdate-min(creation_time)) * 7,1) growth_7_days
    from v$datafile df ,v$tablespace ts where df.ts#=ts.ts# group by df.ts#, order by df.ts#;

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.