Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Capacity Planning

Re: Capacity Planning

From: Sandeep Dubey <dubey.sandeep_at_gmail.com>
Date: Thu, 23 Feb 2006 12:30:08 -0500
Message-ID: <bf2f74740602230930h12b3510fw2b5aaf9a6031430d@mail.gmail.com>


Capacity planning can be divided into disk, cpu and memory planning. We have a similar HW setup in the test environment. For disk planning you really have to load data and calculate disk space taken. Other guessetimates are just guess. E.g if x rows are inserted per day in real environment and you want to store data for y months, load a sample data and calculate. Extrapolate for next three years.

For CPU planning we simulate the expected load on the system, monitor CPU usage. We plan to get 50% average CPU usage max not exceeding 90%. If on the test load you are getting high CPU, look at application if it can be further tuned. If not you need more CPU power. Same goes with memory. If you are getting too much paging and swapping time to get more memory.

Regards

Sandeep

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 23 2006 - 11:30:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US