Re: Question About MTS

Arthur

MTS is needed in one of two situations:

1. Your server is low on memory and you want to share resources via the shared servers instead of dedicated ones for each connection. Normally, this will perform worse than dedicated due to the communication overhead. However, if you swap to dedicated and don't have enough memory it could perform worse than MTS.
2. You are on Oracle8 and you want to use either the Connection Manager or connection pooling functionalities. Both these require MTS.

Not sure what you're trying to get at with the listener question. You certainly still need a listener for connections across the network.

HTH. Pete

Arthur Merar wrote:

> Hello,
>
> We are running the MTS configuration at work. I have heard a lot of
> different opinions about this setup. Many people say it really has no
> big effect on data base access and such.
>
> Is this true?
>
> If I wanted to remove MTS, other than taking the parameters out of the
> init.ora file, what else would I need to do?
>
> If I do remove MTS, do I still need to be concerned about the
> listener?
>
> Thanks for your help and opinions,
>
> Please CC a copy of your reply to my e-mail.
>
> Arthur
> amerar_at_unsu.com

--
Regards

Pete

Received on Fri Jul 16 1999 - 11:08:39 CDT