select
  CCLASS_NAME,                             -- CCLASS_NAME VARCHAR2(1024)
  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
from
  GV$CPOOL_CC_STATS
where
  inst_id=USERENV('Instance')