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_at_news1.rdc2.pa.home.com>#1/1
Date: 2000/04/27
Message-ID: <9v2O4.155671$Tn4.1014693_at_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...Received on Thu Apr 27 2000 - 00:00:00 CEST
> 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
>