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 |
Note:
1. New in 11g.
Oracle data dictionary views
Last updated: 2009-11-24 Tuesday |
No comments:
Post a Comment