Re: how to differentiate multi-threaded or dedicated server?

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/04/27
Message-ID: <9v2O4.155671$Tn4.1014693@news1.rdc2.pa.home.com>#1/1

Are you interested in knowing how the client is connected or if MTS is running or not?

The field server in the v$session table will tell you how the client is connected.

There are several mts_... parameters that are used to setup mts in the init.ora.

--
Robert Fazio, Oracle DBA.
rfazio_at_home.com
http://24.8.218.197/
"Tiaw Wee Lim" <wltiaw_at_ecssin.com.sg> wrote in message
news:3904E9FA.ACE4DA7D_at_ecssin.com.sg...


> Guys,

>

> I have a 8i database box, can anyone knows how to differentiate

> multi-threaded or dedicated server? Any parameters to look for? Please

> advice.

>

> thanks

> Tiaw Wee Lim

>

Received on Thu Apr 27 2000 - 00:00:00 CDT