Query to find database monthly growth

 

This document describes how to find the monthly database growth rate in last one year.

Use the below query to find database monthly growth.

set pagesize 50000

tti "Database growth per month for last year"
select to_char(creation_time, 'RRRR Month') "Month",
       sum(bytes)/1024/1024/1024 "Growth in GB"
  from sys.v_$datafile
where creation_time > SYSDATE-365
group by to_char(creation_time, 'RRRR Month')

/

Thanks for going through this post..................