Re: Sizing Oracle server

Hi Jensen,

The required system that you had proposed is definitely of an enterprise level. Having needed to support of 900 concurrent users, you may need up to 2 to 4 GB of memory in order to meet the fast response time. Besides, that there are factors
that you need to consider. They are as follows, just for your guideline. But it may
varies.

1. The number of CPUs and the speed. I suggest go up to 4 CPUs if possible and take latest speed that is available.
2. The speed of the harddisk and number of harddisk that you have. The speed of the harddisk allows faster retreival of data and at the same time, more harddisks will reduce the problem of harddisk contention.
3. The size of network pipe. Compare a 10 Base T to 100 Base T to ATM. They will make a different in network traffic whick eventually helps you to solve the problem of response time to user.
4. Lastly, you may decide to have a bigger size for your DB_BLOCK rather than the default size which is 2k. The bigger size, the more DB_BLOCK can be read at one time. However, there are minor setback.
5. Tuning memory is subjective. However during setup, take the large size in your init.ora file. Thereafter tune it accordingly.

That is about all. I hope it will help.

Kenny

A Jensen wrote:

> I hope someone can give me some clues, tips, resources on the topic of
> deciding hardware for a server that is to run NT4 Server and Oracle 8.0.5.
> Our database will have approx. 900 concurrent users. They will in average do
> 3-4 transactions a second. How much memory will a connection require? Which
> other aspects should I consider when it comes to determinig memory?
>
> A. Jensen
Received on Tue Feb 23 1999 - 22:16:03 CST