How to find database growth on a Monthly wise

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; Output […]

Read More