From alan.aschenbrenner@ihs.com Tue, 17 Jun 2003 12:47:43 -0700 From: alan.aschenbrenner@ihs.com Date: Tue, 17 Jun 2003 12:47:43 -0700 Subject: RE: JDBC and MTS Message-ID: MIME-Version: 1.0 Content-Type: text/plain The bug Jeffrey is referring to is supposedly fixed in 8.1.7 (but I've seen metalink posts that suggest otherwise). The bug numbers are 1304130 and 1309641 - the dispatcher goes to sleep occasionally for 60 seconds before waking up and servicing requests again... Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] "Jeffrey Beckstrom" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: .org> Subject: RE: JDBC and MTS Sent by: [EMAIL PROTECTED] .com 06/17/03 11:14 AM Please respond to ORACLE-L I recall an old bug where MTS would sleep for a bit - don't recall the bug anymore. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 >>> [EMAIL PROTECTED] 6/17/03 12:35:20 PM >>> b) I use server=dedicated, is srvr=dedicate a short hand version of it? -----Original Message----- Sent: Tuesday, June 17, 2003 8:25 AM To: Multiple recipients of list ORACLE-L OK. Let me get some things straight: a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way, my job is gone. b) The whole problem is that even after specifying SRVR=DEDICATED in the connect string, the darned thing still connects as an MTS connection. c) What was the issue that you faced? That was my original question. On 2003.06.17 07:09, Regis Biassala wrote: > Richard is right...If ur Java application uses it own connection > pooling...then do not use MTS...it slows down connections and more...We > faced the same issue here.... > > Our configuration allows DBA to choose weather connection pooling should > handled by the app or the database... > Use dedicated servers if there's noway you can disable the application > connection pooling... > > > Regis > > -----Original Message----- > Sent: Tuesday, June 17, 2003 6:05 AM > To: Multiple recipients of list ORACLE-L > > > I used to seen problems with JDBC Thin with MTS on Linux and switching to > a dedicated connection seemed to fix the problem. But JDBC Thin and MTS > worked fine on my Solaris box. Not sure with HP-UX. Is the Java > application > running on an Application Server? > > Richard Ji > > -----Original Message----- > Sent: Monday, June 16, 2003 11:25 PM > To: Multiple recipients of list ORACLE-L > > > I'm not a Java expert so please forgive me my ignorance. JDBC application > is facing very strange performance problems during connect. Every now and > then > everything appears to be hung and then, 10 minutes later, users proceed > normally but with the elevated blood pressure and serious lack of patience. > I was told that JDBC has it's own connection pooling mechanism and that it > will start it's own dedicated server connection. It seems though that the > string "SRVR=DEDICATED" has been ignored and that users are acquiring a > shared > server connection. > Does anybody in this group have any experience with JDBC and MTS? Version is > 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with > listeners on all 4 nodes for load balancing purposes. I found surprisingly > little material on the Metalink. No network collisions, no retransmits, no > timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet > and I would be very surprised if approximately 100 users could kill it with > a > JDBC application. They could use DBA as a human sacrifice, though. > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net > -- > Author: Richard Ji > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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). > ********************************************************************* > This electronic transmission is strictly confidential and intended solely > for the addressee. It may contain information which is covered by legal, > professional or other privilege. If you are not the intended addressee, > you must not disclose, copy or take any action in reliance of this > transmission. If you have received this transmission in error, > please notify the sender as soon as possible. > > This footnote also confirms that this message has been swept > for computer viruses. > ********************************************************************** > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Regis Biassala > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).