Re: MTS oracle 8.1.7

"MT" <mtechera_at_wpmc.com> wrote in message news:am4pgn$g14$1_at_news.online.de...
> Hello All:
>
>
> Ora 8.1.7 AIX
>
> What is the easiest way to tell if MTS is turned on?

MTS_DISPATCHERS is the key parameter that "turns on" MTS.

You could also look at the services for the listener(s) for the database to see if dispatchers have been registered.

You could also look at V$CIRCUITS to see how many connections have been made via dispatchers. V$DISPATCHER, V$DISPATCHER_RATE, V$MTS and V$SHARED_SERVER (among others) all gives you useful information.

>
> How can it be turned off?

Comment out the MTS_DISPATCHERS and it's turned off. No dispatchers, no MTS.

>
> Is there any risk in turning off?

If the reason you have MTS turned on is so that you can handle the 5000 connections required to the database, then turning it off will have a rather unfortunate consequence (as these connections will now each demand their own dedicated connection, and the resource overheads this entails).

Before turning it off, you need to ask why it was turned on in the first place, and can a dedicated configuration handle the required dedicated load.

Note also that "features" such as connection manager and IIOP connections require MTS to be configured at the backend so you may need to suss this out as well.

Cheers

Richard

>
> Thanks,
> Mario
>
>
Received on Mon Sep 16 2002 - 09:44:53 CDT