DBA_CPOOL_INFO displays configuration information about all Database Resident Connection Pools in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the connection pool |
|
|
|
|
Status of the pool:
|
|
|
|
|
Minimum number of pooled servers that are always alive in the pool |
|
|
|
|
Maximum number of pooled servers in the pool |
|
|
|
|
Number of pooled servers by which the pool is incremented if servers are unavailable when a client application request is received |
|
|
|
|
Number of session cursors to cache in each pooled server |
|
|
|
|
Maximum time (in seconds) that the pooled server can stay idle in the pool. After this time, the server is terminated. |
|
|
|
|
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. |
|
|
|
|
Number of times a pooled server can be taken and released to the pool |
|
|
|
|
Time (in seconds) for a pooled server to live in the pool |
|
|
|
|
Number of connection brokers spawned per instance |
|
|
|
|
Maximum number of connections per connection broker |
See Also:
Oracle Database Administrator's Guide for more information about the configuration parameters for Database Resident Connection Pooling
Oracle Database PL/SQL Packages and Types Reference for more information on the DBMS_CONNECTION_POOL package