Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DB Sizing
Ram,
The way that I've always done this is to ask the customer to get some "test" data loaded into the database. Gather stats on all of the tables once the data has been loaded. Ask the customer for a table-by-table list of how many records will be added to each table per year.
You can then calculate estimates a couple of ways. The simplest way is to look at how much space each table is using and then calculate how much it would use when fully populated. Simple comparisons are pretty god.
For example: If you test table currently has 10,000 records and it is using 1 Meg of space, then 100,000 records would use "about" 10Meg of space. Don't forget to include the index usage in your calculations. This is by far the simplest method - and you should add some space to cover mis-calculations.
A more thorough way is to look at the "space calculations" formulas in the concepts manual. It requires the same information to start as the above method. I like this method better because you can include in your report a statement that says "This is how Oracle says to calculate space usage". It helps to stop people from second-guessing how you came up with a number.
Just remember to cover yourself when you deliver the "best guess" by saying somewthing like "This is as good as I can come up with right now - but things may change as the database grows".
Good Luck!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org]
Sent: Tuesday, February 24, 2004 7:58 AM
To: oracle-l_at_freelists.org
Subject: Re: DB Sizing
Ram,
The Oracle manuals will give you an idea on the database sizing. It is
different for each customer. Some will add GIG's of data each year and
others won't. I would suggest that you read ans understand the Oracle
Concepts Manual, Administrators Guide, Installation Guides, and any of
the many books published about the subject.
The customer has to provide you with some information that will guide
you in the decision process.
Ron
>>> senthilkumard_at_summitworks.com 02/24/2004 6:41:36 AM >>> Hi,
I'm a new DBA.
I want to know how do i size my database. Any doc's are available for
this.
One of my customer is asking me to give a detailed report for his
database
sizing.
Do anybody have any checklist or any formula for sizing the db. I'm
using
8.1.7.
TIA
Ram
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
![]() |
![]() |