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