Thank you for visiting Spatial DBA - Oracle and ArcSDE.
I have stopped updating the blog.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
=================================================================
V$CPOOL_STATS displays information about the Database Resident Connection Pool statistics for an instance.
Column | Datatype | Description |
POOL_NAME | VARCHAR2(1024) | Name of the Database Resident Connection Pool |
NUM_OPEN_SERVERS | NUMBER | Total number of busy and free servers in the pool (including the authentication servers) |
NUM_BUSY_SERVERS | NUMBER | Total number of busy servers in the pool (not including the authentication servers) |
NUM_AUTH_SERVERS | NUMBER | Number of authentication servers in the pool |
NUM_REQUESTS | NUMBER | Number of client requests |
NUM_HITS | NUMBER | Total number of times client requests found matching pooled servers in the pool |
NUM_MISSES | NUMBER | Total number of times client requests could not find a matching pooled server in the pool |
NUM_WAITS | NUMBER | Total number of client requests that had to wait due to non-availability of free pooled servers |
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 |
NUM_PURGED | NUMBER | Total number of sessions purged by the pool |
HISTORIC_MAX | NUMBER | Maximum size that the pool has ever reached |
Note:
1. New in 11g.
Oracle data dictionary views
Last updated: 2009-11-24 Tuesday |
No comments:
Post a Comment