select server, count(*) from v$session group by server; 'SHARED' and 'NONE' show MTS sessions. Tanel. ----- Original Message ----- From: "Seema Singh" <oracledbam@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Friday, July 23, 2004 8:50 PM Subject: MTS > Hi, > which parameter/sql statement show how many processes are connected with > dispatcher or shared servers in MTS configuration. > thanks > -seema > > _________________________________________________________________ > Is your PC infected? Get a FREE online computer virus scan from McAfee® > Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------