Re: MTS Question

The need to run MTS or not is largely dependent on system resources. I deal with a system that has about 40-80 users logged in with multiple client apps across sqlnet. Before we turned on MTS we were bringing the system to its knees after about ten workstations logged in. After switching to MTS we have been blithly adding more users and the only thing I have done is add a few more server processes to help carry the load.

If you want to turn MTS off, just comment out all of the mts parameters in your initxxx.ora file and bounce the database. If all of your apps are host-based then you really won't need the listener, but if you are connecting via sqlnet from outside the host then you'll still need to have the listener up so that the connection can be handed off to a dedicated server.

Personally I've never seen a case where having MTS up where it is not really needed has degraded performance in such a way that turning MTS off will improve things. If you are concerned about the resources being used you can always cut back to just a single dispatcher and a single server process, but if there are no solid justifications I don't think there is any advantage of turning MTS off.

Ken

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
Received on Fri Jul 16 1999 - 07:14:48 CDT