4.174 DBA_CPOOL_INFO
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 |
|
|
|
Maximum time of inactivity (in seconds) for a client after it obtains a pooled server from the pool and starts a transaction. If the client application does not issue a database call for the time specified by |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
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