Here’s a new version of the database growth report. The new version determines the growth trend for the database for the past one year. Check out this script:

set pages 255 lines 2000 trims on
compute sum of growth_in_gb on report
col week_number for a35
break on report
select to_char(creation_time, 'ww mon yyyy') week_number, round(sum(bytes)/1024/1024/1024,1) growth_in_gb
from sys.v_$datafile
where creation_time > SYSDATE-365
group by to_char(creation_time, 'ww mon yyyy')
order by 1

Posted by Charles Kim, Oracle ACE Director

Leave a Reply

Your email address will not be published. Required fields are marked *