Re: [Q] How many client processes Oracle can support?

In article <4ovjq8$t7h_at_news2.cais.com>, MCC <duffy_at_cais.cais.com> wrote:
>We have Oracle 7.2.3 and SQL*NET 2.2 installed on SUN SPARC server
>(SOLARIS 2.5). On client site, we will have hundred's PC use SQL*NET 2.2
>to connect to ORACLE server. I wonder how many client processes ORACLE
>and SQl*NET can support simultaneous? Do I need change UNIX MAX processes
>number? Anything else I should do on ORACLE and UNIX? Thank you for
>help.

The number of connections you can support will be mainly linked to the amount of RAM you have on the server, and how busy the clients are.

You should DEFINITELY look into the MTS server configuration. It's simple to configure, as long as you already have SQL*Net V2 running. Basically, it lets multiple client processes use the same threaded server process. It saves enormously on resources, by saving on the number of processes owned by Oracle, and on the amount of RAM allocated each.

Look in your administrator's guide. The only work to be done is to set three or four parameters in your INIT.ORA.

Good luck,
Kevin Fries

-- 
-------------------------------------------------------------
Kevin Fries                         kelfink_at_ecst.csuchico.edu
CPD/PB, C Developer/DBA  http://www.ecst.csuchico.edu/~kelfink