Rem OWNED shows no. of clients currently connected Rem select name "NAME", owned,substr(network,1,15) "PROTOCOL", status "STATUS", (busy/(busy + idle)) * 100 "%TIME BUSY" from v$dispatcher / Rem Queue wait time select paddr,type,queued,wait,totalq, decode(totalq,0,0,wait/totalq) "AVG WAIT" from v$queue;