Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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