RE: MTS vs. Dedicated connection

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>=20

	-----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