Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need to track the size of various DBs we have, then see it's growth rate so that we can guess where it will be at certain times. I'm using Oracle 11g first, but will eventually be applying this to other DBMSs like DB2 and Sybase.

I'm not even sure where to begin or what commands/queries I'll need to run.

share|improve this question
    
There's a lot of info on how to determine a database's size on the internet, is there anything specific you're not managing to do? (And that'll be different for each and every database engine, unless you go the easy and inaccurate route and measure disk usage.) –  Mat Jul 1 '13 at 16:38
add comment

1 Answer

You just need to start by collecting data.

There are a few different valid ways of judging the size of the database -- number of rows in each table, size of table and index extents, size of data files -- so first you have to define what decisions you intend to make based on the data. Do you want to know when you'll need to add storage? Or when you'll need to extend data files?

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.