RE: MTS vs. Dedicated connection

Yes for some purpose you do need Dedicated Connection even if you are using MTS, some of them are:
<<<<
To submit a batch job (for example, when a job can allow little or no idle time for the server process)

To use Enterprise Manager to start up, shut down, or perform media recovery on a database

To use Recovery Manager to back up, restore or recover a database
>>>>

NOTE: These are exerts from Oracle Manual. HTH,
Rajesh
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Nikunj Gupta
Sent: Thursday, January 11, 2001 10: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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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