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
