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.

Salim Dawood

Published: 16 Jun 2004

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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

SearchERP

How to list rows with special characters in PL/SQL

Oracle instance tuning techniques

ORA-03001 error with dynamic query

"Select star" with column reformatting

Please create a username to comment.

Executive shuffle rolls through ERP industry

Top 5 inventory management techniques

SAP competitors see openings with S/4HANA qualms

Oracle Autonomous Database shifts IT focus to strategic planning

Oracle Autonomous Database features free DBAs from routine tasks

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Where InfluxDB time series database is going

MariaDB X4 brings smart transactions to open source database

How data lineage tools boost data governance policies

AWS security faces challenges after a decade of dominance

AWS AI tools focus on developers

Perform an AWS security assessment with these tips and tools

Storytelling using data makes information easy to digest

Data-driven storytelling makes data accessible

Startup Uplevel targets software engineering efficiency

4 popular content collaboration platforms to consider

AI can enhance content security with a bit of planning

Ex-SAP exec steers Episerver CMS toward digital experience market

Why mobile recruiting is the future

Top 7 HR trends for 2020 and beyond: The change decade

For insider threat programs, HR should provide checks and balances

Dig Deeper on SAP Basis

How to list rows with special characters in PL/SQL

Oracle instance tuning techniques

ORA-03001 error with dynamic query

"Select star" with column reformatting

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.