📋Steps in this guide1/1

Database growth per month

select to_char(creation_time, 'MM-RRRR') "Month", sum(bytes)/1024/1024/1024 "Growth in GB from sys.v_$datafile where to_char(creation_time,'RRRR')='&YEAR_IN_YYYY_FORMAT' group by to_char(creation_time, 'MM-RRRR') order by to_char(creation_time, 'MM-RRRR');

oracle configurationintermediate

by OracleDba

13 views

Database growth per month

Code/Command (click line numbers to comment):

select to_char(creation_time, 'MM-RRRR') "Month", sum(bytes)/1024/1024/1024 "Growth in GB
from sys.v_$datafile
where to_char(creation_time,'RRRR')='&YEAR_IN_YYYY_FORMAT'
group by to_char(creation_time, 'MM-RRRR')
order by to_char(creation_time, 'MM-RRRR');

Comments (0)

Please to add comments

No comments yet. Be the first to comment!