750 is my optimistic number. I am really only expecting to get about
400 to 500 on the server and still get achieve the desired level of
performance, however, I will be testing this later today. I will also
look into using MTS. Thank you for your help.
"daniel" <test_at_test.com> wrote in message news:<a7hrdf$8qt$1_at_news6.svr.pol.co.uk>...
> 750 users with that amount of mem ??? you would have to do the sums
> will it be performant??? test, test and re test
> also think about mts
>
> daniel...
>
> "Jason Ayres" <jayres_at_bridge-way.com> wrote in message
> news:a56bad00.0203212018.1e1f46ba_at_posting.google.com...
> > 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 Sun Mar 24 2002 - 06:43:11 CST
