Hi Friends, In our application the number of concurrent users have increased , we thought of increasing the maximum connection cpacity in the weblogic 7.0.Can you please suggest what is the maximum value it can accept? Is it that the weblogic alone decides on number of connection that it can establish with the back end(oracle 9i) or the db server have to give a specification on the allowed maximum connection..
This can be specified in the database as well as in Weblogic.
In the database it is the initialization parameter SESSIONS. Also the PROCESSES init parameter can also affect matters. In dedicated server mode I believe you can't have more active sessions than there are processes.
This answer only applies to Oracle - but since you posted this question in the Oracle / OAS forum as well then this answer applies to you. [ November 03, 2007: Message edited by: Chris Hendy ]