| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: MTS vs. Dedicated connection
Patrice,
Well, I'm not using NT, but I did get MTS working on 8 & 8.1.6 on HP-= UX. =
Works just fine, but there are potential performance problems. I would N=
OT
recommend it to anyone where your end users are blasting large amounts of=
data
or SQL at the server. It is great for applications where you have lots o=
f user
sessions, small amounts of SQL & data being processed/transferred like an=
OLTP
environment.
Dick Goulet
____________________Reply Separator____________________Subject: RE: MTS vs. Dedicated connection Author: "Boivin; Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca> Date: 1/11/2001 8:28 AM
Maybe someone has managed to make it work, but during my Oracle 8i Upgrad=
e
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=3Ddedicated) in my tnsnames=
=2Eora
file and surprise, all the problems went away. I am almost using the ver=
y
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 fo=
r
8i, but the examples never seemed to quite fit my situation - which is ve=
ry
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, b=
ut
after a day of tweaking those .ora files the ability for clients to conne=
ct
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 t=
o
hear about that.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst=E8mes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique = Maritimes Region, DFO | R=E9gion 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 shoul=
d
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 wa=
s
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 wa=
s
hours
> to complete. By simply changing from @PROD (via MTS) to @PROD_D=
ED
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 / Mailin=
g
>
> To REMOVE yourself from this mailing list, send an E-Mail messa=
ge
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') an=
d
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-50=
51
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 m=
ay
also send the HELP command for other information (like subscribin=
g).
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 Received on Thu Jan 11 2001 - 14:58:15 CST
 |
 |