Re: MTS oracle 8.1.7

On Tue, 17 Sep 2002 00:44:53 +1000, "Richard Foote" <richard.foote_at_bigpond.com> wrote:

>
>"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?
select DECODE ( value,0, 'MTS is OFF', 'MTS is ON')  from v$parameter where name = 'mts_servers';

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

AND parameter MTS_SERVERS (must be > 0).
>
>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.
>

OR (to disable MTS immediately without restarting the instance ):

"alter system set MTS_SERVERS = 0"
>>
>> 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
>>
>>
>
>

• Kenneth Koenraadt