doc

    Name:    mtsresp.sql

    Author:  Mark Gurry

    This script shows the Multi-Threaded Server response times.

#

SELECT NETWORK, DECODE (SUM(TOTALQ), 0 , "NO RESPONSES",
       SUM(WAIT)/SUM(TOTALQ) || '   100THS SECS') "AVERAGE WAIT "
  FROM V$QUEUE Q, V$DISPATCHER D
 WHERE Q.TYPE = 'DISPATCHER’
   AND Q.PADDR = D.PADDR
 GROUP BY NETWORK;