RE: JDBC and MTS

From: <alan.aschenbrenner_at_ihs.com>
Date: Tue, 17 Jun 2003 12:47:43 -0700
Message-ID: <F001.005B33DB.20030617115456@fatcity.com>

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).

Received on Tue Jun 17 2003 - 14:47:43 CDT