RE: MTS vs. Dedicated connection

Getting MTS to work as far as connecting to the database isn't difficult, and there are some things such as IIOP connections which require it. There are a few things to look out for. MTS adversely impacts the shared pool. There is a large_pool_size init.ora parameter to mitigate this. If your database activity is not constant, but is subject to bursts, the shared servers can be gobbled up at an amazing rate, even if the activity is comprised of simple queries returning small amounts of data.

Ian A MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu   

-----Original Message-----
From: jared still [mailto:jkstill_at_teleport.com] Sent: Thursday, January 11, 2001 4:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: MTS vs. Dedicated connection

On Thu, 11 Jan 2001, Boivin, Patrice J wrote:

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

That's a little disconcerting coming from and Oracle instructor.

We had MTS working way back on 7.0.16.

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;) jkstill_at_teleport.com
jared_still_at_enron.net

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: jared still
  INET: jkstill_at_teleport.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).