Re: MTS

From: Tracy Rahmlow <tracy.rahmlow_at_aexp.com>
Date: Fri, 23 Jul 2004 13:03:54 -0500
Message-ID: <OFEA97C904.D52F396D-ON86256EDA.00625CBD-86256EDA.00633067@ipc.us.aexp.com>

Here is some sql you can start with ("salt to taste"): SELECT name, network, status, owned "PER CONNECT", (busy/(busy+idle)) * 100 "% OF TIME BUSY"
FROM v$dispatcher;

SELECT name, paddr, status, requests, busy, idle, (busy/(busy+idle))* 100 "% OF TIME BUSY"
FROM v$shared_server;

SELECT paddr, type "QUEUE TYPE", queued "# QUEUED", wait, totalq,

                  decode(totalq,0,0,wait/totalq) "AVG WAIT hundreths of a

sec"
FROM v$queue q;

SELECT COUNT (*) "TOTAL MTS CONNECTIONS" FROM v$session
WHERE server != 'DEDICATED';

SELECT p.spid "UNIX PROCESS ID", c.saddr, c.circuit, c.dispatcher, c.server, c.status,

                  s.sid, s.serial#, substr(c.queue,1,15) "QUEUE", c.waiter

FROM v$circuit c, v$process p, v$session s WHERE c.dispatcher=p.addr
AND c.saddr=s.saddr;

SELECT count(*), program, server
FROM v$session
GROUP BY program, server;

"Seema Singh" <oracledbam_at_hotmail.com>
Sent by: oracle-l-bounce_at_freelists.org
07/23/2004 12:50 PM
Please respond to oracle-l

        To:     oracle-l_at_freelists.org
        cc: 
        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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

American Express made the following
annotations on 07/23/2004 11:13:29 AM

"This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you."

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Fri Jul 23 2004 - 13:10:13 CDT