Database Growth Month wise:-
set pagesize 5000
tti "Database
growth per month for last year"
select
to_char(creation_time, 'RRRR Month') "Month",
sum(bytes)/1024/1024 "Growth in
Meg"
from sys.v_$datafile
where creation_time > SYSDATE-365
group by to_char(creation_time, 'RRRR Month')
/
No comments:
Post a Comment