I am a software engineer and working as an Oracle Apps DBA. I have started this blog to share my knowledge with others . Here you can find stuff related to Oracle DBA,Oracle Applications DBA,
Friday, October 14, 2016
Find the Database Growth by Monthly Basis
select to_char(creation_time, 'YYYY Month') "Month", sum(bytes)/1024/1024 "Growth in MB" from sys.v_$datafile where creation_time > SYSDATE-365 group by to_char(creation_time, 'YYYY Month');
No comments:
Post a Comment