8.152 V$CPOOL_STATS
V$CPOOL_STATS
displays information about the Database Resident Connection Pool statistics for an instance.
Column | Datatype | Description |
---|---|---|
|
|
Name of the Database Resident Connection Pool |
|
|
Total number of busy and free servers in the pool (including the authentication servers) |
|
|
Total number of busy servers in the pool (not including the authentication servers) |
|
|
Number of authentication servers in the pool |
|
|
Number of client requests |
|
|
Total number of times client requests found matching pooled servers in the pool |
|
|
Total number of times client requests could not find a matching pooled server in the pool |
|
|
Total number of client requests that had to wait due to non-availability of free pooled servers |
|
|
Reserved for future use |
|
|
Reserved for future use |
|
|
Total number of authentications of clients done by the pool |
|
|
Total number of sessions purged by the pool |
|
|
Maximum size that the pool has ever reached |
|
|
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.