How to find oracle database monthly growth

How to find oracle database monthly growth


set pagesize 50000


tti "Database growth per month for last year"

select to_char(creation_time, 'RRRR Month') "Month",

       sum(bytes)/1024/1024/1024 "Growth in GB"

  from sys.v_$datafile

where creation_time > SYSDATE-365

group by to_char(creation_time, 'RRRR Month')

/

Comments

Popular posts from this blog

ORA-01565: error in identifying file '?/dbs/spfile@.ora'

Reboot Exadata Machine

How to combine Oracle .ova files