V$CPOOL_STATS definition in Oracle Database 11.2
V$CPOOL_STATS

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')

home |  up