Hi Mladen We started evaluating MTS and JDBC Thin Driver (newest version for JDK 1.4, running on Win2k against a test db on win2k, test db is oracle 9.2.0.3.0). I never used SRVR=DEDICATED. I have a dispatcher running on port 5000 and a listener on port 1521. The only thing I do to direct the connection to either use MTS or dedicated server is setting the port it connects to to either 1521 or 5000. That works just fine.
Stefan -----Ursprüngliche Nachricht----- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Juni 2003 14:25 An: Multiple recipients of list ORACLE-L Betreff: Re: JDBC and MTS 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: Stefan Jahnke 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).