select to_char(creation_time, 'RRRR Month') "Month",
sum(bytes)/1024/1024 "Growth in Meg"
from sys.v_$datafile
where to_char(creation_time, 'RRRR Month') like '2007%'
group by to_char(creation_time, 'RRRR Month')
/
Subscribe to:
Post Comments (Atom)
Posts
1 comment:
This may actually be slightly dangerous since, if you've done a reorganisation at the datafile level then you'll get unexplained spikes in your growth chart.
Granted, in steady state conditions, the SQL will allow you to see absolute growth.
Post a Comment