Tracking database growth

A nice little sqlplus script that can extract the database growth by month over a 2 year period from an SAP/Oracle database.

A nice little sqlplus script that can extract the database growth by month over a 2 year period from an SAP/Oracle database.
column bytes format 999,999,999,999 heading "Bytes Alloc."
select to_char(creation_time, 'YYYY') "Year",
to_char(creation_time, 'MM') "MM",
round(sum(bytes)/1024/1024,0) "Growth in Meg"
from sys.v_$datafile
where creation_time > SYSDATE-730
group by to_char(creation_time, 'YYYY'),
to_char(creation_time, 'MM')
order by to_char(creation_time, 'YYYY') desc,
to_char(creation_time, 'MM') desc
/
This was first published in June 2004

Dig deeper on SAP Basis administration and NetWeaver administration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close