Oracle-L: RE: Capacity Planning -- Expecting the DB growth !!!

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 17 Dec 2002 06:23:50 -0800
Message-ID: <F001.0051B303.20021217062350@fatcity.com>

Reddy - Step number one is to immediately begin collecting size data. For most sites, storing a weekly count of the number of rows in each table is sufficient. Usually combine it with regular ANALYZE TABLE or DBMS_STATS executions. This will be your basis for making projections.

Then get to know the factors that influence the growth. You mention events such as holidays as an example. But some sites are affected more by the holidays than others. If your developers are adding features to the database, that will influence growth. I have one application whose busy season is the springtime.

As far as automation, just having the information in a database table allows you to perform forecasts just using simple SQL commands. In my experience the problem with total automation is that the questions keep changing. Periodically you will be asked a question related to capacity, but the question is usually one you haven't thought of before, but with a base of history you can figure out the answer.

Inevitably Pareto's Rule (a.k.a. 80/20 principle) plays heavily. Just a handful of tables will contain most of your growth. If you can predict those correctly, the rest falls into place. That table that holds 10 rows and just might grow to 12 rows in 2 years isn't going to be your challenge.

Many packages that monitor performance over the long term also perform capacity planning. I think OEM has this capability. Just go to www.google.com <http://www.google.com> and enter "Oracle Capacity Planning", and you will see many interesting sites.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, December 16, 2002 8:19 PM
To: Multiple recipients of list ORACLE-L

Hello All,

I am currently working on capacity planning of the database , expecting the database size based on the business object ,sales ( Historical data). I am not sure about the approach I am following . I believe there might be some better approach followed in some shop to estimate the DB size , even by considering events like "thanks giving" , "holiday season" and all.

Also I have to automate this process. Would like to know some best suggestions you always have in this forum. Would you help me in identifying some formulae. Any kind of documentation will be a great help !!!

Thanks in advance,

Madhu

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Dec 17 2002 - 08:23:50 CST