Oracle教程

Oracle 视图 DBA_CPOOL_INFO 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图DBA_CPOOL_INFO是数据库中执行PL/SQL函数时使用连接池（Connection Pool）的描述信息。

连接池由重用的数据库连接组成，可以被放到数据库服务器资源的可用连接池中，供应用程序使用。当客户端应用程序要请求数据库连接时，它可以从池中获取一个当前处于空闲状态的连接，而无需每次都新建或者进行释放连接，从而节省带宽和网络资源，提高数据库性能。

DBA_CPOOL_INFO视图提供以下信息：

1. 连接池所要重用的目标连接
2. 连接池的当前连接计数
3. 连接池使用的最大数量
4. 连接池是否可用

使用DBA_CPOOL_INFO视图可以查看数据库中所有连接池的情况，可以查看连接池的状态、使用的最大连接数量和当前使用的连接数，以及是否可用。可以用这些信息来进行容量规划、性能分析以及连接池管理工作。

官方英文解释

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:

  • ACTIVE

  • INACTIVE

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

NUM_CBROK

NUMBER

Number of connection brokers spawned per instance

MAXCONN_CBROK

NUMBER

Maximum number of connections per connection broker

MAX_TXN_THINK_TIME

NUMBER

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 MAX_TXN_THINK_TIME while in a transaction, the pooled server is freed, the transaction is rolled back, and the client connection is terminated. The default value is 0, which means MAX_THINK_TIME applies for all connections, irrespective of transactions being open or not in those connections. Care should be taken while setting the two parameters MAX_THINK_TIME and MAX_TXN_THINK_TIME to higher values, as it would mean the servers are not released to the pool for a longer time, even if clients are not responding for any reason, thereby making other users wait unnecessarily.

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire multitenant container database (CDB). This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

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


数据运维技术 » Oracle 视图 DBA_CPOOL_INFO 官方解释，作用，如何使用详细说明
分享到：

相关推荐