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

How to list rows with special characters in PL/SQL Want to learn how to list rows with special characters in PL/SQL? Read this tip from our PL/SQL expert for advice on how to write a PL/SQL query using the translate, char or trunk functions.

Oracle instance tuning techniques Oracle professionals know that you must optimize your database by tuning global parameters before detailed application tuning can proceed. This excerpt from the best-selling book "Oracle Tuning: The Definitive Reference" reviews proven techniques for tuning any Oracle instance and has scripts to ensure that your database is optimized for its application load.

ORA-03001 error with dynamic query I am using a dynamic query (with the help of EXECUTE IMMEDIATE) in the function and within the dynamic SQL I am calling another function created by me. But when I execute the function I am getting an error: "ORA-03001 unimplemented feature."

"Select star" with column reformatting Let's say I have a data table that has columns A-Z and column C is for Date-Time. I want to see all of the columns in my table. When I do a "Select * from datatable" the return is the standard DD-Mon-YY. My question is, can I still use a Select * query and be able to view all of the columns and the full date and time info, or is my only option to select each column and use the TO_CHAR for column C?

DISTINCT is not a function My question is related to count(*) and distinct. How can I list results where count(*) is greater than 2?

Converting from CHAR to DATE datatype As a time value, I used the CHAR datatype and need to convert to a DATE value while manipulating/computing. How do I use the DATE datatype instead?

SearchERP

Please create a username to comment.

RPA in manufacturing increases efficiency, reduces costs

A look inside the new Redwood Oracle UI design

Process mining software pulls back curtains on how processes work

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

Amazon Managed Apache Cassandra Service stokes competition

Aerospike 4.8 advances database persistent memory support

Data warehouse technologies evolve as vendors look skyward

Prepare for an AWS outage with these preventative steps

AWS seeks niche in the cloud UC market

National Australia Bank cashes in on AWS training and certification

Government IT pros: Hiring data scientists isn't an exact science

Tableau 2020.1 unveiled for beta testing

Data scientist vs. data analyst: What's the difference?

DNA as a content storage device is closer than you think

Acquia acquisition of AgilOne CDP signals CX platform expansion

Personalization engines help engage and retain customers

US Army HR expects migration to Azure cloud will cut IT costs

H-1B lottery change may drive increase in visa applicants

Fight the skills gap with a great upskilling and reskilling strategy

Dig Deeper on SAP Basis

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.