RE: RE: MTS vs. Dedicated connection

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Fri, 12 Jan 2001 09:09:07 -0400
Message-Id: <10739.126482@fatcity.com>

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

=09

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

Received on Fri Jan 12 2001 - 07:09:07 CST