doc

    Name:    mtsavwat.sql

    Author:  Mark Gurry

    This script shows the Multi-Threaded Server average wait details.

#

SELECT DECODE( TOTALQ, 0, 'NO REQUESTS'
           WAIT/TOTALQ ||'  100THS SECS') "AVERAGE WAIT"
  FROM V$QUEUE
 WHERE type = ‘COMMON’;