Kirti - I'm hoping you get some really good replies to this because it looks
like I'll be the victim of BEA shortly. Just my pessimistic side. I really
mean to say that the developers will be using WebLogic and I'll have to
figure it out from the Oracle perspective.
My guess is that WebLogic probably offers different options for how it
handles connection pooling. I located the following document on BEA's
website.
http://www.weblogic.com/docs51/classdocs/conn_pools.html
My guess is that the default settings are being used and you just need to
learn how to adjust them.
A good JDBC reference that discusses the connection pooling options is
"Java Programming with Oracle JDBC" by Donald Bales. It doesn't say much
about J2EE and EJB and certainly nothing about WebLogic configuration, so I
can't say whether it would apply here or not.
Again, I hope someone that really understands this situation will
respond. Maybe if they overlook your note, my ignorance will irritate them
into responding.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, June 27, 2002 10: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.
- Kirti
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
