Re: MTS oracle 8.1.7

Thank you for the help Richard and Kenneth!

I was able to confirm that MTS is on, as you suggested but unfortunately it is not clear if it is necessary or not for it to remain turned on
(I am playing the role of an assistant here).

One follow up question:

Is there any way to determine if any of the current session are coming from the MTS dispatcher by looking at some of the DBA_ views? Or would this have to be done by looking at the OS processes?

Thanks again!

Mario

<kennethkoenraadt_at_no-spam.hotmail.com> wrote in message news:3d85f807.613111_at_news.mobilixnet.dk...
> 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
Received on Mon Sep 16 2002 - 12:26:52 CDT