Kirti,
I forgot to add this: If you are using Thin clients you can't read v$session properly. For some reason it doesn't populate properly and you can't correlate anything. Regs, Sujatha -----Original Message----- Sent: Friday, 28 June 2002 4:03 PM To: Multiple recipients of list ORACLE-L Kirti, Taking another tack... Why would they want to use JDBC Thin? Typically, the "thin" driver is intended for environments where the "Oracle Client" is not expected to be installed (i.e. applets on the browser) and the JDBC "OCI" driver for environments where the "Oracle Client" is expected to be installed (i.e. servlets on the app server). JDBC Thin has some nasty quirks beyond not populating V$SESSION properly. For example, if a database object or a cursor should go invalid for any reason, a "thin" driver cannot handle the problem as an "OCI" driver can... Just some food for thought... -Tim ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 9:53 AM > 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: Tim Gorman 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: Sujatha Madan 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).
