Search This Blog

Total Pageviews

Monday, 19 September 2011

Oracle database growth

Oracle database growth by month over 2 years


select to_char(creation_time, 'YYYY') "Month", to_char(creation_time, 'MM') "Month", round(sum(bytes)/1024/1024,0) "Growth in Meg" 
from sys.v_$datafile 
where creation_time > SYSDATE-730 
group by to_char(creation_time, 'YYYY'),to_char(creation_time, 'MM') 
order by to_char(creation_time, 'YYYY') desc, to_char(creation_time, 'MM') desc  
/



Mont Mo Growth in Meg
---- -- -------------
2011 04           650
2010 09          3584


============

set pagesize 300
BREAK ON YEAR SKIP 1
COMPUTE SUM LABEL 'TOTAL' OF "Approx_No_files" ON YEAR

col "YEAR" for a15
col "Month" for a15
select to_char(creation_time, 'YYYY') "YEAR", to_char(creation_time, 'MM') "Month", round(sum(bytes)/1024/1024/1024,0) "Growth in GB",round((round(sum(bytes)/1024/1024/1024,0))/32) "Approx_No_files"
from sys.v_$datafile
where 1=1
--and creation_time > SYSDATE-3000
group by to_char(creation_time, 'YYYY'),to_char(creation_time, 'MM')
order by to_char(creation_time, 'YYYY') desc, to_char(creation_time, 'MM') desc
/

YEAR            MONTH           GROWTH_IN_GB APPROX_NO_FILE
--------------- --------------- ------------ --------------
2022            02                        76              2
                01                       779             24
***************                              --------------
TOTAL                                                    26

No comments:

Oracle DBA

anuj blog Archive