Re: MTS vs. Dedicated connection

I have made MTS work in 8.1.7, no problems. Except for Weblogic which experienced *very* slow response time with MTS, and I'm not certain if the cause was MTS or how Weblogic does connection pooling. Anyone using Weblogic that has seen this???

Other than Weblogic, I've used MTS from Oracle 7.x through 8i with very few problems. This was all on Unix so I can't speak for NT.

"Boivin, Patrice J" wrote:
>
> Maybe someone has managed to make it work, but during my Oracle 8i Upgrade
> course the instructor mentioned that he never managed to make MTS work in
> Oracle7, and in 8i he couldn't make it work either.
>
> I installed 8.1.6. on a test server here, I spent about a day trying to
> connect to it remotely, finally I put (server=dedicated) in my tnsnames.ora
> file and surprise, all the problems went away. I am almost using the very
> same configuration that we are using for Oracle7, except for the
> listener.ora file where SID has been replaced by SERVICE_NAME.
>
> During that day I tried to understand the info on how to configure MTS for
> 8i, but the examples never seemed to quite fit my situation - which is very
> simple: I want my users to be able to connect, and I want to be able to use
> MTS server-side. We are using TCP/IP, and my test server here is an NT
> machine. If connection pooling and multiplexing works, all the better, but
> after a day of tweaking those .ora files the ability for clients to connect
> became a lot more important than those other improvements to MTS.
>
> If someone has managed to make MTS work properly in 8.1.6, I would like to
> hear about that.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
> Systems Admin & Operations | Admin. et Exploit. des systèmes
> Technology Services | Services technologiques
> Informatics Branch | Direction de l'informatique
> Maritimes Region, DFO | Région des Maritimes, MPO
>
> E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
>
> -----Original Message-----
> From: Nikunj Gupta [SMTP:good_dba_at_hotmail.com]
> Sent: Thursday, January 11, 2001 2:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: MTS vs. Dedicated connection
>
> Does that mean even after configuring MTS .. the connection should
> be
> dedicated ?
>
> Can anyone highlight the benefits of MTS with Shared Connection /
> MTS with
> Dedicated Connection and
> simple dedicated connected without MTS.
>
> What would be the best situation to configure MTS. (Only more
> numbers of
> users with less I/O to server etc.)
>
> TIA
>
> Nikunj
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, January 09, 2001 02:07 PM
>
> > Once again I solved a SQL*net performance problem where data was
> being
> SELECTed
> > via a DB_LINK from a remote system and being INSERTed into the
> local
> instance.
> >
> > The original code was going into the remote host via MTS and was
> taking 3+
> hours
> > to complete. By simply changing from @PROD (via MTS) to @PROD_DED
> (via
> dedicated
> > listener) the run time was reduced to about 4 MINUTES! This was
> the ONLY
> change.
> >
> > HTH & YMMV!
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Charlie Mengler
> > INET: charliem_at_mwh.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> > San Diego, California -- Public Internet access / Mailing
> Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (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.com
> --
> Author: Nikunj Gupta
> INET: good_dba_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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.com
> --
> Author: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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
Received on Thu Jan 11 2001 - 16:18:46 CST