Re: Oracle Performance on NT

In article <58eecf$q31_at_alpha.ftech.net>, surjit_at_dualalpha.co.uk says...
>
>I am working as a DBA on a site were they are using NT3.51 and Oracle
>7.2..2.4. The NT Server has two 133mhz pentium processors and 128 meg
>of memory.

128 MB is quite low. That's about the minimum I recommend for small installs. A larger one like this will not be able to give you performance on 128 mb.

>The application which is being developed will typically perform a
>dozen selects, two or three inserts and a couple of updates.
>
>They are looking to get two hundred cocurrent users on the system,
>although at a given time not all the sessions will be active.

For 200+ users two Intel 133's is probably not enough. You *might* get away with two 180mhz or better 200mhz Pentium Pro's. If you're stuck with the 133, I'd get four to have the room. And your memory is not even close. I'd give at least 8mb per user, I wouldn't be comfortable with anything less than 2gb. You can probably get away with that since few systems of 200 users have *every* station being that busy.

>My question is has anybody managed to set up a database on NT which
>can handled the above throughput.
>
> I now it's a vague question but i would like to get feeling of whats
>been acheived on Oracle on NT.

I have seen 200+ on NT with Oracle, but with a DEC Alpha. You'll need a lot more horse power than what you've got to make it run reasonably.

Geoff Crawford                            Phone:      (201) 627 - 0307
Innovative Client Servers                 FAX:        (201) 627 - 0634
24 Dogwood Drive                          Email:    geoff_at_innov8cs.com
Denville NJ 07834                         Web: http://www.innov8cs.com