SQL> select decode(totalq,0,'Norequests') "wait time",
2 wait/totalq||'hundredths ofseconds' "Average wait time per request"
3 from v$queue
4 where type='COMMON';
wait time Average wait time per request
------------------------------------------------------------------------
0hundredths of seconds
0hundredths of seconds