Re: Maximum users per Oracle server

Given the configuration of this machine, do you think with 4 GB or 6 GB of RAM that it would be possible to run 750 concurrent users on the server and still have good performance? Do you have idea what the maximum number of concurrent users for this machine would be? I know that it really depends on the application, but again, the application is rather small (100 MB).

Thanks

"daniel" <test_at_test.com> wrote in message news:<a7ddbd$7e5$1_at_newsg3.svr.pol.co.uk>...
> Hi,
>
> Your question seems to be a bit vague, but I think you are asking how many
> concurrent users will your system handle?
>
> So 2Gb ram
> minus OS stuff
> minus "other" process (unless dedicated Oracle server)
> minus the SGA (buffer cache & shared pool)
> and each concurrent user will take (rule of thumb) approx 2Mb
>
> If you are planning large numbers of users you may look at an MTS
> environment.
>
> Any questions please ask...
>
> Daniel...
>
> "Jason Ayres" <jayres_at_bridge-way.com> wrote in message
> news:a56bad00.0203210844.6f32951d_at_posting.google.com...
> > I am trying to figure out how many users I can fit on one Oracle
> > server. The server will be used to host a database (our application)
> > for various clients. The server will contain one instance and be
> > comprised of multiple schemas (one for each client). Each schema will
> > contain about 140 tables and on average about 100 MB of data. The
> > server is running dual Pentium III 933 MHz Xeon processors and 2 GB of
> > RAM (can be increased to 4 GB later) with 3 arrays of RAID-5 (I
> > couldn't get 0+1 approved at the time), and separate drives for redo
> > logs, archive logs, and the OS (all 10K SCSI drives). It is running
> > Oracle 8.1.7 Standard Edition on Windows 2000 Server. I know a lot
> > depends on the application and access patterns of the users, however,
> > I would be very grateful just to hear some ballpark figures or
> > experiences you have had with a similar configuration. Ideally, I
> > would use a cluster running Oracle9i RAC, but it's a little pricey. I
> > know it is very scalable so at some point it may be more profitable
> > than multiple servers running Oracle SE. Please just let me know what
> > you think.
> >
> > Thanks
Received on Thu Mar 21 2002 - 22:18:17 CST