| 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: RE: MTS vs. Dedicated connection
Patrice,
One of the nice things about Oracle is that although they pay homage =
to the
corporate mantra, at the same time they understand the REAL WORLD. For a=
number
of years I've heard that rule based optimization & OCI were going away. =
Well,
there still here & I haven't heard/read anything that says their leaving =
in 9i
either. Yeah Larry E wants to become the internet company of the world, =
there
was even a move afoot a year or two ago to make Oracle and the OS one and=
the
same. Died on the vine. Why? Because reality bites, the bulk of his rev=
enue
comes on the back of the RDBMS one way or the other and folks use it for =
more
than the internet. We've got 10+ instances here and only one has anythin=
g to do
with the internet. The others support more mundane things, like an autom=
ated
manufacturing line or two. So don't worry, if it comes to pass we'll all=
get
more than fair warning, but don't bet on it being to soon. What I believ=
e their
trying to do is get us DBA's to use some of these new technologies so tha=
t when
we do have the millions of sessions predicted we'll be ready & understand=
=2E BTW:
anyone running an ASP based application on either an inter or intra net s=
hould
be looking at MTS. It really does save the server some heartburn.
Dick Goulet
____________________Reply Separator____________________Subject: RE: RE: MTS vs. Dedicated connection Author: "Boivin; Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca> Date: 1/12/2001 5:10 AM
That's a little worrisome.
My Oracle8i instructor (the one who said he could not make MTS work) said=
that eventually, Oracle plans to phase out dedicated connections.
One student asked how this could be, it isn't possible to restart databas=
es
via MTS because none of the processes are up. The instructor didn't have=
an
answer for him.
Is this a bad rumour, that Oracle will eventually drop dedicated connecti=
ons
and try to get everyone to connect via MTS? Just wondering. It sounds
silly but you never know.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-----Original Message-----
From: dgoulet_at_vicr.com [SMTP:dgoulet_at_vicr.com]
Sent: Thursday, January 11, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: MTS vs. Dedicated connection
Patrice,
Well, I'm not using NT, but I did get MTS working on 8 & 8.1.=
6
Works just fine, but there are potential performance problems. I=
would NOT
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 hav=
e
lots of user
sessions, small amounts of SQL & data being processed/transferred=
like an OLTP
environment.
Dick Goulet
____________________Reply Separator____________________
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 8=
i
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 try=
ing
to
connect to it remotely, finally I put (server=3Ddedicated) 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 configur=
e
8i, but the examples never seemed to quite fit my situation - whi=
ch
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 woul=
d
like to
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 connecti=
on
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 i=
nto
local
instance.
>
> The original code was going into the remote host via MT=
S
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: (8=
58)
538-5051
> San Diego, California -- Public Internet access =
/
Lists
>
-----------------------------------------------------------------=
---
> To REMOVE yourself from this mailing list, send an E-Ma=
il
> 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 fro=
m).
may
> also send the HELP command for other information (like
subscribing).
>
-- =
Please see the official ORACLE-L FAQ: http://www.orafaq.c=
om
-- =
Author: Nikunj Gupta
INET: good_dba_at_hotmail.com
Fat City Network Services -- (858) 538-5051 FAX: (858=
)
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 'ListGur=
u')
the message BODY, include a line containing: UNSUB ORACLE=
-L
(or the name of mailing list you want to be removed from)=
=2E
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-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: =
INET: dgoulet_at_vicr.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 Received on Fri Jan 12 2001 - 08:18:25 CST
 |
 |