SELECT DECODE(SUM(totalq),0,’No Responses’, 
 SUM(wait)/SUM(totalq)) “Average wait TIME” 
 FROM v$queue q,v$dispatcher d 
 WHERE q.TYPE = ‘DISPATCHER’ 
 AND q.paddr = d.paddr;  

Show comments for this question (1)
Add comments
Link to this question