DBA_CPOOL_INFO displays configuration information about all Database Resident Connection Pools in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
CONNECTION_POOL |
VARCHAR2(128) |
Name of the connection pool | |
STATUS |
VARCHAR2(16) |
Status of the pool:
|
|
MINSIZE |
NUMBER |
Minimum number of pooled servers that are always alive in the pool | |
MAXSIZE |
NUMBER |
Maximum number of pooled servers in the pool | |
INCRSIZE |
NUMBER |
Number of pooled servers by which the pool is incremented if servers are unavailable when a client application request is received | |
SESSION_CACHED_CURSORS |
NUMBER |
Number of session cursors to cache in each pooled server | |
INACTIVITY_TIMEOUT |
NUMBER |
Maximum time (in seconds) that the pooled server can stay idle in the pool. After this time, the server is terminated. | |
MAX_THINK_TIME |
NUMBER |
Maximum time of inactivity (in seconds) for a client after obtaining a pooled server from the pool. After obtaining a pooled server from the pool, if the client application does not issue a database call for the time specified by this column, then the pooled server is freed and the client connection is terminated. | |
MAX_USE_SESSION |
NUMBER |
Number of times a pooled server can be taken and released to the pool | |
MAX_LIFETIME_SESSION |
NUMBER |
Time (in seconds) for a pooled server to live in the pool |