| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: WebLogic, Oracle JDBC related
Hi Kirti,
We ran into the same kind of issues with IBM's Websphere. I think that is kind of like WebLogic.
We kept hitting max_processes each time and the customer blamed the listener then they blamed the firewall for timing all the connections out. After extensive tests we found that it was a problem with the Websphere config files. I've pasted some details the IBM Websphere applications guys sent to me. It may help you.
CONNECTION POOLING PERFORMANCE TUNNING: MINIMUM POOL SIZE It is important to adjust connection pooling properties for optimal performance by applications that require connection to a database. You can adjust connection pooling properties using Admin Console.
In the first in a series of tips on tuning connection pooling performance, we look at Minimum Pool Size property settings. Minimum Pool Size specifies the minimum number of connections that the connection pool should hold open to the database. The default value for this property is 1.
In WAS 3.5 and 4.0, the connection pool doesn't create the minimum number of database connections at the outset. Instead, the connection pool grows by creating new connections as they are needed. After the pool has grown to the minimum number of connections, this minimum is maintained. That is, the number of connections doesn't fall below the specified minimum.
To determine the appropriate minimum value, you must examine the applications that use the connection pool, making note of the minimum number of connections that are needed at any point in time. You should set the Minimum Pool Size property to this minimum value so requests can be satisfied without connection wait timeout exceptions.
Remember that the number of connections can grow beyond the minimum number specified in Minimum Pool Size. During periods of low activity, the number of open connections decreases to the minimum. You should keep the Minimum Pool Size value as low as possible to avoid holding extraneous connections open.
Cheers
Sujatha
-----Original Message-----
Sent: Friday, 28 June 2002 1:53 AM
To: Multiple recipients of list ORACLE-L
We are in the process of rolling out a Web Appl that uses BEA WebLogic and Oracle JDBC, thin driver calls to connect to database. These are dedicated connections (No MTS). The listener is overwhelmed with connection requests that at times reach 250+ per second. The 'preferred vendor' is blaming it on the limitation of the Listener, that is not capable of handling this load.
I suspect this fine piece of software is not using JDBC connection pooling. Is there any way to find out if that's indeed the case? I am not involved in this project, and may not get access to the Appl Code. A co-worker is asking me all kinds of questions about Listener problems. The Vendor is suggesting to increase the QueueSize for the listener. They have already created multiple listeners in vain.
I think the Appl code is to blame. I do not know much about Java/EJB etc.. but my hunch is that this EJB container stuff does not smell good. For all I know it could be making a db connection for every single thing and disconnecting.
Anyone dealt with similar issues?
All tips are welcome and appreciated.
All right, the preferred vendor is AMDOCS. Anyone running any of their Web Applications? If so, can you please contact me off-list?
Thanks.
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 28 2002 - 01:23:19 CDT
 |
 |