Thanks to all who responded (Brian, Doug, David J., Christoph, Paul, Steve,
Vladik, Malcolm, Don and David)
MTS refers to "Oracle Multi-Threaded Server" it's an Oracle question not a
system question.
I'll use Vladik's answer to summarize:
"Oracle support referred to "Oracle Multi-Threaded Server". This falls
under the
DBA's area of responsibility. This is when you run a bunch of Oracle
"dispatcher" services. Each "dispatcher" service will serve, for example, 20
Oracle client connections. In the "Single-Threaded Server" Oracle will spawn a
dedicated service process for each Oracle client request."
By default the standard Oracle database is NOT multi-threaded. To find if
you are using MTS you can check the init.ora parameter file in your
$ORACLE_HOME/dbs directory and look for parameters beginning with 'mts_'
such as, mts_dispatchers=.
Or you can do ps auxww | grep ora_s00 or ps auxww | grep ora_d00 if no
processes are shown, MTS is not running.
Original Question:
> Hi,
>
> this is one probably fits in the stupid question category,
> but here it is
> anyway.
> The dba asked me (he was asked by Oracle support) if we were
> running an MTS
> system.
> My answer was what do you mean by MTS. So he went back to
> Oracle and asked
> what they meant by MTS and they meant Multi-Thread system.
> Does their question make sense, ie is Tru64 UNIX 4.0D a
> Multi-Thread system
> ? Shouldn't the question be is your Oracle application
> Multi-Threaded, in
> which case the dba should know the answer ?
>
Received on Tue Feb 20 2001 - 18:57:59 NZDT