Oracle11i Requirements

[Faizer Jameel]

Hello ;
Well I would like someone who has installed Oracle11i applications to share some requiremnts that I am looking for
the memory requirements [ detail] per user.
We have 200 users who would be using the Oracle11i. In addition we would be implementing this on a HP Vclass server[ 2250]
This would help me to plan the implementation.
Thankyou in advance for the prompt and usual cooperation.

[Thierry Poels_1]

Hi,
Oracle 11i ?? wow ;)
I thought Oracle 8.1.7 was the latest version available, and Oracle 9i comming out soon.
For 200 users on an Oracle Server I would go for at least 2GB of RAM, but probably even more.
But memory sizing depends on the applications the server will run. I once advised 512MB for just a few users, but eventually the application launched +/- 10 Oracle processes per user and users seemed to login more than once; so the 512MB RAM turned out to be rather thight.
good luck,
Thierry.

[Thierry Poels_1]

sjips, just noted a little word:
Oracle 11i <>
Sorry, I'm currently distracted by the finals at Roland Garros ;)
Thierry.

[Faizer Jameel]

Slip of the fingers is no fault of the brain.
the requirement is for Oracle 11i Applications [ 11.5.3] for 8.1.6

[Bill Hassell]

It is very difficult to predict a size requirement until the transaction rate and desired response time is known. If you want sub-second response for 100+ transactions per second, you will probably need 5000 to 16000 megs of RAM, much of it will be assigned to SGA to allow tables and most indexes to eliminate disk searches.

Another unknown is the efficiency of the database searches for common transactions. A poor design will require full table searches while a good design will use partials.

A good starting point is a class on Oracle for HP-UX SysAdmins.

[Bill McNAMARA_1]

Any online Oracle for HP-UX Admins course.?

Later,
Bill