Re: Sizing System Memory/CPU for Oracle

Hiya

Thanks for the details.

Marcus

On Wed, 05 Apr 2000 23:39:44 -0400, Jerry Gitomer <jgitomer_at_erols.com> wrote:

>Marcus wrote:
>>
>> Does anyone know how to calculate the system requirements (Memory and
>> CPU etc) for a Oracle Database, or where I can obtain any guidance?
>>
>> I will have about (on average) 158 concurrently active users, using 16
>> Oracle Modules!
>>
>> I have to size a Server for an Oracle DataBase. Is there a sizing
>> guide or do/have you had this in the past? I was (a long time ago)
>> told to calculate about 4MB per user plus a bit etc? I think
>> DataBases have gone past that calculation method now!
>>
>> Any help would be very appreciated.
>>
>> Marcus
>
> I prefer the simplistic approach -- order the maximum amount of
>memory that the hardware vendor supports ;-)
>
> The problem with more scientific approaches is that they require
>you to make assumptions about the job mix, the size of the tables
>that will be accessed simultaneously and are based on the premise
>that the application(s) have been designed and implemented in an
>optimal manner.
>
> If it is a question of justifying the additional memory to
>management just ask the suits how much growth they expect over
>the next five years. Since they all assume that they are such
>wonderful managers and that their competitors are asleep at the
>switch they will come up with optimistic estimates. You can then
>look very serious while punching random phone numbers into your
>pocket calculator (or PDA, if you have one) and then say "X GB
>should hold us." where X is the maximum RAM you can install in
>the box.
>
Received on Thu Apr 06 2000 - 18:55:52 CDT