SELECT COUNT(*),USERNAME,MACHINE,SERVICE,CONNECTION_STATUS FROM GV$CPOOL_CONN_INFO
WHERE CONNECTION_STATUS='IDLE'
GROUP BY (CONNECTION_STATUS,SERVICE,MACHINE,USERNAME)
ORDER BY MACHINE;