RE: JDBC and MTS

Mladen - I'll add what I know, but it won't add much.

When the Java people say they are doing "connection pooling", that almost certainly means they are using an application server. This is the beast on which to focus your attention. Start by finding out which species it is. There are in my experience, a variety of settings related to AS connection pooling. It is easy to get those settings wrong, which can produce a variety of bad effects on the database end. They can create too many sessions, or too few.

   In my simple view, MTS and connection pooling do the same thing. I don't use MTS, so I'm assuming here. But I can see that using both MTS and connection pooling at the same time might produce bad effects.

   The other thing to remember about the thin client is that it does not use Net8. It does not rely on a tnsnames.ora file on the client (application server in this case). It connects directly to the listener. One possibility to test would be to switch to the thick client. That may be better in your situation.

   Good luck and keep us posted. We DBAs are all facing this webbified/Javafied/.netified world and we've got to stick together.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] -----Original Message-----
Sent: Tuesday, June 17, 2003 7: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: DENNIS WILLIAMS
  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).