doc

    Name:    mtswait.sql

    Author:  Mark Gurry

    This script shows the Multi-Threaded Server waits.

#

SELECT NETWORK, SUM(BUSY) / (SUM(BUSY) + SUM(IDLE)) "BUSY RATE"
  FROM V$DISPATCHER
 GROUP BY NETWORK;