Well, I may suggest: - make sure that you are working with a 8.1.7.4 Oracle Server (that is the final release); - cut down the maxActive to 100 (or 50 as you consider apt): this is due to behaviour of a pooled resource: if there is a peak of requests the pool will reply opening a huge number of connection on the db server, and closing them after a long time: of course this will cause the db server ram to thrash. - for the same reason move to WHEN_EXHAUSTED_BLOCK, so some users will wait for peak to move along. - and finally, test everything under stress.
Hope may help daniele rizzi Scrive raj <[EMAIL PROTECTED]>: > Hello Dirk and Other Experts, > > I need help in indentifying stand DBCP POOl parameters > for approxly 200 users(using DB transaction via > connaction pooling ) and other 200 other means of DB > trasactions . > We are using JRUN 3x, Iplanet 4.1 servicepack 5, > Oracle 8.1.7. and > commons-pool-1.1.jar and commons-dbcp-1.1.jar. > > The current parameter are .. > > connectionPool.setTestOnBorrow(true); > connectionPool.setTestOnReturn(true); > connectionPool.setMaxActive(400); > connectionPool.setMaxIdle(40); > connectionPool.setMinIdle(20); > connectionPool.setWhenExhaustedAction(connectionPool.WHEN_EXHAUSTED_GROW); > connectionPool.setNumTestsPerEvictionRun(20); > connectionPool.setMinEvictableIdleTimeMillis(600000); > connectionPool.setTimeBetweenEvictionRunsMillis(10000); > // 10 sec > > Could some one confirm these and also specify any > potential problems as well as specify your > recommendations. > > I appreciate your time and help in this regard. > > Thanks in Advance. > Regards..RAJ > > > > > > > __________________________________ > Do you Yahoo!? > Win a $20,000 Career Makeover at Yahoo! HotJobs > http://hotjobs.sweepstakes.yahoo.com/careermakeover > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
