Re: MTS oracle 8.1.7

On Mon, 16 Sep 2002 18:26:52 +0100, "MT" <mtechera_at_wpmc.com> wrote:

>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

Hi Mario,

Try :

select sid,serial#,username,SERVER
from v$session
where username is not null

The SERVER column shows either "DEDICATED" or "SHARED", the last one indicates a MTS connection.

• Kenneth Koenraadt
  >
  >
  >
  ><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
  >
  >