Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: JDBC and MTS

RE: JDBC and MTS

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 17 Jun 2003 10:05:33 -0700
Message-ID: <F001.005B31BB.20030617091452@fatcity.com>

I recall an old bug where MTS would sleep for a bit - don't recall the bug anymore.
 
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, 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 ofit?-----Original Message-----Sent: Tuesday, June 17, 2003 8:25 AMTo: Multiple recipients of list ORACLE-LOK. 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: <A href="http://www.orafaq.net">http://www.orafaq.net> --> Author: Mladen Gogala>   INET: [EMAIL PROTECTED]> > Fat City Network Services    -- 858-538-5051 <A href="http://www.fatcity.com">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: <A
href="http://www.orafaq.net">http://www.orafaq.net> --> Author: Richard Ji>   INET: [EMAIL PROTECTED]> > Fat City Network Services    -- 858-538-5051 <A href="http://www.fatcity.com">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: <A href="http://www.orafaq.net">http://www.orafaq.net> --> Author: Regis Biassala>   INET:
[EMAIL PROTECTED]> > Fat City Network
Services    -- 858-538-5051 <A
href="http://www.fatcity.com">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 GogalaOracle 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 <A
href="http://www.fatcity.com">http://www.fatcity.comSan Diego, California        -- Mailing list and web hosting
services---------------------------------------------------------------------To 
REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso 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 <A
href="http://www.fatcity.com">http://www.fatcity.comSan Diego, California        -- Mailing list and web hosting
services---------------------------------------------------------------------To 
REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing). Received on Tue Jun 17 2003 - 12:05:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US