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.

  • 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, 2013 at 16:38

1 Answer 1


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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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