Oracle教程 2023-02-24

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

——内存池信息视图

Oracle视图V$CPOOL_STATS是一种按内存池分类的信息视图，主要指示内存池状态。用户可以通过该视图查看到内存池的名称、大小、已使用量等信息。

使用V$CPOOL_STATS主要可以检查Linux 内存池的使用情况，确定是否存在内存碎片或内存过大的问题，以及Oracle系统是否内存泄露等。

具体使用方法为：
SELECT * FROM V$CPOOL_STATS;
该命令可查询出当前数据库中所有内存池的信息，用户可以查询当前内存池的信息，做出正确的内存管理决策。

V$CPOOL_STATS displays information about the Database Resident Connection Pool statistics for an instance.

Column	Datatype	Description
`POOL_NAME`	`VARCHAR2(1024)`	Name of the Database Resident Connection Pool
`NUM_OPEN_SERVERS`	`NUMBER`	Total number of busy and free servers in the pool (including the authentication servers)
`NUM_BUSY_SERVERS`	`NUMBER`	Total number of busy servers in the pool (not including the authentication servers)
`NUM_AUTH_SERVERS`	`NUMBER`	Number of authentication servers in the pool
`NUM_REQUESTS`	`NUMBER`	Number of client requests
`NUM_HITS`	`NUMBER`	Total number of times client requests found matching pooled servers in the pool
`NUM_MISSES`	`NUMBER`	Total number of times client requests could not find a matching pooled server in the pool
`NUM_WAITS`	`NUMBER`	Total number of client requests that had to wait due to non-availability of free pooled servers
`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
`NUM_PURGED`	`NUMBER`	Total number of sessions purged by the pool
`HISTORIC_MAX`	`NUMBER`	Maximum size that the pool has ever reached
`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 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

Note:

This view returns data only when queried from a CDB root. When queried from a PDB, this view returns 0 rows.

分享到：