Problem solve Get help with specific problems with your technologies, process and projects.

Tracking database growth

A nice little sqlplus script that can extract the database growth by month over a two-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
/

Dig Deeper on SAP Basis

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchContentManagement

SearchHRSoftware

Close