Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

optimal Connection pool size?

 
babu lingam
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am having WAS 3.5.3 running on Windows 2000, Oracle 8.1.7 database on a UNIX box. I am having 200 client application hitting the WAS box through a Servlet. Each application opens 4 connections directly from the oracle DB for some non WebSphere activity (as the client apps are written in VJ++, they use ADO to connection to the DB). Also, a few modules in the client apps post to the Servlet which needs 3 DB connections on an average.
So if one client app is running it requires 4 (thro ADO) + 3 (thro WebSphere Connection Pool) = 7 connections.
For 200 clients running concurrently 200 X 7 = 1400 connections are needed in the Oracle DB.
Is it reasonable to set
1)processes = 150 in init.ora in the oracle
2)Min Connection pool size = 10; Max Connection pool size = 600 in Datasource property of WAS.
The numbers ‘1400’ and ‘600’ looks huge.
Considering the performance how much will be optimal value for each of the settings?
I found this in WAS info center :
Rule Of Thumb to calculate Max connectin pool size:
n* (T * (C - 1) + 1)
where
T = no of threads
n = no. of client apps. Which initiates these threads
C = no. of DB connections opened by each thread
Applying this formula in my case 200*(1*(3-1) +1) = 600.
Any suggestions would be helpful
Thanks in advance
babu
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic