Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection Pool - No of connections

 
Malli Raman
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1. How to find out the maximum capacity of the Connection Pool for Weblogic Server 6.1 and Oracle 8i.
2. In my appln(Intranet), we expected that 500 user can access the database at a time. I don't know how to judge the max capacity (no of connections) of the connection Pool. Can i set it to 50 and set the autoshrink to True.
Regards,
Raman
--------------------
 
Chris Mathews
Ranch Hand
Posts: 2712
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Set your capacity to some sufficiently high number, say 50 - 75. Make sure Oracle is configured to allow that many concurrent sessions (actually a few more), it shouldn't be a problem though because I think Oracle defaults to 200. Make sure Oracle will allow enough cursors to be open concurrently, especially if you are using the prepared statement cache.
Set on autoshrink.
Let it run that way for a few weeks and check the stats on the WebLogic and adjust accordingly based on those stats.
[ September 21, 2002: Message edited by: Chris Mathews ]
 
Dave Landers
Ranch Hand
Posts: 401
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
One thing to note - in normal circumstances, you can set your database connections to approximately the same as the number of execute threads. Uaually just a few more than that. The execute threads control how many user threads (i.e. call to servlet or RMI or EJB, etc) are running on the system at any one time, so you will not have more simultaneous database connections than that.
The exceptions are things like multiple connections per thread or stateful session beans that hang on to a connection and outlive the user thread, etc.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic