8.150 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 |
---|---|---|
|
|
Name of the Database Resident Connection Pool |
|
|
Name of the connection class |
|
|
Number of session requests |
|
|
Total number of times a session that matches with the request was found in the pool |
|
|
Total number of times an exact match to the request was not found in the pool and a new session had to be created |
|
|
Total number of times session requests had to wait before getting served |
|
|
Reserved for future use |
|
|
Reserved for future use |
|
|
Total number of authentications of clients done by the pool |
|
|
The ID of the container to which the data pertains. Possible values include:
|
Note:
This view returns data only when queried from a CDB root. When queried from a PDB, this view returns 0 rows.