Oracle教程

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

本站中文解释

Oracle视图V$CPOOL_CC_STATS是“内存分析$内存池$缓存计数统计”视图，主要用于查看当前计数的缓存的统计信息。

此视图包含的列有：
＊POOL_ADDR：内存池的地址
＊CACHE_COUNT：缓存计数
＊CACHE_COUNT_LAST_SCANNED：最后一次扫描时的缓存计数
＊TOTAL_ACP_SEEN：被计算的ACP(Automatic Workload Repository池缓存页)总数
＊MAX_ACP_SEEN：被计算的最大ACP数
＊CACHE_COUNT_TIME：最后一次计算缓存计数的时间

使用：
使用该视图可以查看当前计数的缓存的统计信息，以进一步判断当前应用程序可能存在的内存问题，定位和分析缓存计数相关的性能问题。

语法：
SELECT *
FROM V$CPOOL_CC_STATS;

官方英文解释

V$CPOOL_CC_STATS displays information about the connection class level statistics for the Database Resident Connection Pool per instance.

Column Datatype Description

CCLASS_NAME

VARCHAR2(1024)

Name of the connection class

NUM_REQUESTS

NUMBER

Number of session requests

NUM_HITS

NUMBER

Total number of times a session that matches with the request was found in the pool

NUM_MISSES

NUMBER

Total number of times an exact match to the request was not found in the pool and a new session had to be created

NUM_WAITS

NUMBER

Total number of times session requests had to wait before getting served

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

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.


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

相关推荐