Sunday, August 16, 2015

Oracle : Script lists the details of database growth per month

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