Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

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

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$CPOOL_CC_STATS

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