select
POOL_NAME, -- POOL_NAME VARCHAR2(1024)
NUM_OPEN_SERVERS, -- NUM_OPEN_SERVERS NUMBER
NUM_BUSY_SERVERS, -- NUM_BUSY_SERVERS NUMBER
NUM_AUTH_SERVERS, -- NUM_AUTH_SERVERS NUMBER
NUM_REQUESTS, -- NUM_REQUESTS NUMBER
NUM_HITS, -- NUM_HITS NUMBER
NUM_MISSES, -- NUM_MISSES NUMBER
NUM_WAITS, -- NUM_WAITS NUMBER
WAIT_TIME, -- WAIT_TIME NUMBER
CLIENT_REQ_TIMEOUTS, -- CLIENT_REQ_TIMEOUTS NUMBER
NUM_AUTHENTICATIONS, -- NUM_AUTHENTICATIONS NUMBER
NUM_PURGED, -- NUM_PURGED NUMBER
HISTORIC_MAX -- HISTORIC_MAX NUMBER
from
GV$CPOOL_STATS
where
inst_id=USERENV('Instance')