Re: Capacity Planning.

For starters, you are going to require some information from the project manager/developers/users or whoever is driving the project.

Avg # of users simultaneously connected
Avg # of transactions
Avg transaction size

Desired average response time. This should really be part of a Service Level Agreement.

You will need this information to make any kind of meaningful estimate of the CPU power and memory requirements.

A good site to visit for a CPU capacity planning tool is www.orapub.com. There you will find an MS Excel workbook that uses queuing theory to help determine the proper number of CPU's, and the percentage of utilization .

Practical capacity planning dictates that your system should utilize have a 70% maximum CPU utilization under normal load, though I prefer the margin of error that 60% provides.

Determining memory requirements is much easier. On top of your estimated SGA size, add 15 meg of RAM for each user session, this has been my observation for Oracle 8i. Though a session may only use 8-10 meg, I would rather have more memory than immediately necessary than not enough. The 16 meg was observed on a DW with a SORT_AREA_SIZE of 5 meg.

Memory utilization per user can be affected by a few other things: With parallel query, multiply the 15 meg by degree of parallelization. SORT_AREA_SIZE will affect this as well.

Once again, you will need those transaction numbers to do any of this. If it is a 3rd party app, they should already have some kind of worksheet to aid in all this.

Jared

On Tuesday 22 May 2001 06:21, Shreepad Vaidya wrote:
> Hi List ,
>
> Any one has any links to white papaers ,ideas on Capacity Planning
> for the database .
> Has anyone been through it all. Could u please guide .
>
> How do u estimate and Project :----
>
> Space required , Cpu Required , Memory required . I have a bit of idea
> about Space estimation . But the other two are completely new ones.
>
> Any additions to the above parameters ........
>
>
>
>
> shreepad .

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).