| 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
They also intend to phase out rule-based optimization but
until they change all their code they can't. I am sure
they will figure it out before they actually do it. =20
-----Original Message-----
From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca]
Sent: Friday, January 12, 2001 5:10 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: MTS vs. Dedicated connection
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 =
databases
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 =
connections
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 on HP-UX.=20 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 have 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 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=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 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=E8mes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique=20 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 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).
>
--=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 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). --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 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 also send the HELP command for other information (like subscribing). --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 Author:=20 INET: dgoulet_at_vicr.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).--=20
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 Received on Fri Jan 12 2001 - 10:37:13 CST
 |
 |