V$CPOOL_CC_STATS displays information about the connection class level statistics for the Database Resident Connection Pool per instance.
| Column | Datatype | Description |
|---|---|---|
CCLASS_NAME |
VARCHAR2(1024) |
Name of the connection class |
NUM_REQUESTS |
NUMBER |
Number of session requests |
NUM_HITS |
NUMBER |
Total number of times a session that matches with the request was found in the pool |
NUM_MISSES |
NUMBER |
Total number of times an exact match to the request was not found in the pool and a new session had to be created |
NUM_WAITS |
NUMBER |
Total number of times session requests had to wait before getting served |
WAIT_TIME |
NUMBER |
Reserved for future use |
CLIENT_REQ_TIMEOUTS |
NUMBER |
Reserved for future use |
NUM_AUTHENTICATIONS |
NUMBER |
Total number of authentications of clients done by the pool |