From: asaf_h@netvision.net.il Subject: Re: [Q] How many client processes Oracle can support? Date: 1996/06/06 Message-ID: #1/1 references: <4ovjq8$t7h@news2.cais.com> content-type: TEXT/PLAIN; charset=US-ASCII organization: NetVision LTD. mime-version: 1.0 newsgroups: comp.databases.oracle In Article<4ovjq8$t7h@news2.cais.com>, writes: > Path: news.NetVision.net.il!psinntp!psinntp!psinntp!howland.reston.ans.net!newsfeed.i nternetmci.com!chi-news.cic.net!news.cais.net!news2.cais.com!cais.cais.com!duff y > From: duffy@cais.cais.com (MCC) > Newsgroups: comp.databases.oracle > Subject: [Q] How many client processes Oracle can support? > Date: 3 Jun 1996 21:00:56 GMT > Organization: Capital Area Internet Service info@cais.com 703-448-4470 > Lines: 6 > Message-ID: <4ovjq8$t7h@news2.cais.com> > NNTP-Posting-Host: cais.com > X-Newsreader: TIN [version 1.2 PL2] > > 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. Hi, In general one should make sure all Unix kernel Parameters regarding semaphores, shared memory and processes are high enough (Refer to Oracle's I.C.Guide for your platform). Keep in mind - each client process will cause a Unix process to be born (Serving client requests against the DB)... If your system reaches the limits as far as #number of users , you may want to try Oracle's MTS or a TP Monitor solution ... Good Luck !