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 ----- From: "Charlie Mengler" <charliem_at_mwh.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, January 09, 2001 02:07 PM Subject: MTS vs. Dedicated connection

> 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).
Received on Thu Jan 11 2001 - 00:49:15 CST