RE: JDBC and MTS

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