RE: no. of users supported

It also depends on the processor speed. WE used to have issues with 8 - 400MHZ CPU with less than 100 connection and mostly select queries. Assuming your hit ratio is close to 100% and with the average run time of the all the queries are less than 20 milliseconds, I don't see any issues with 2 - 1GHZ processor supporting at least 50 users.

-----Original Message-----
From: Dennis Williams [mailto:oracledba.williams_at_gmail.com] Sent: Thursday, September 29, 2005 1:00 PM To: raja4list_at_yahoo.com
Cc: Allan Nelson; oracle list
Subject: Re: no. of users supported

Raj,

> The database is a complete read activity. not much inserts.

In general you are correct that only selects will reduce the server load, meaning the server should be able to support more users. But there are several additional issues:

• Are the queries just retrieving a few rows through indexes, or are full-table scans required?
• Do most of the queries go after the same data, so the popular block are cached in memory, or even use Materialized Views? Or will the queries want data all over the database? What is the I/O subsystem like? You may be better off putting more money in the I/O subsystem than the server.

I have seen Solaris servers easily supporting the number of users you have mentioned.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l