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');
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