Oracle教程 2023-02-23

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

Oracle视图 CLIENT_RESULT_CACHE_STATS$ 是一个视图，可用于检查客户端结果缓存的效率。它报告上一次重复查询的访问次数、使用的访问次数以及每次访问的节省情况。利用此视图，可以了解哪些查询在客户端缓存中有多余的使用，以便可以优化查询，以增加缓存的效率。

要使用此视图，首先应启用客户端结果缓存。在客户端缓存未开启时，此视图将返回空结果。一旦客户端缓存被启用，可以使用如下查询以查询此视图：

SELECT * FROM CLIENT_RESULT_CACHE_STATS$;

CLIENT_RESULT_CACHE_STATS$ displays various client result cache settings and usage statistics.

Statistics are stored as name, value pairs. For each client cache ID, there will be multiple rows for each statistic.

Column	Datatype	NULL	Description
`CACHE_ID`	`NUMBER`	`NOT NULL`	Unique ID per client cache
`STAT_ID`	`NUMBER`	`NOT NULL`	Statistic ID
`NAME`	`VARCHAR2(128)`		Name of the statistic (see Table 4-1)
`VALUE`	`NUMBER`		Value of the statistic

Table 4-1 CLIENT_RESULT_CACHE_STATS$ Statistics

Statistic Name	Description
Block Size	Size (in bytes) of each memory block in the result cache.
Block Count Max	Maximum number of blocks that can be allocated in the result cache based on the cache size configuration parameters on server and on client.
Block Count Current	Current number of blocks allocated by the client result cache.
Hash Bucket Count	Size of the hash table used for query matching.
Create Count Success	Number of cached result sets that did not get invalidated before caching all the rows of the result set.
Create Count Failure	Number of cached result sets that did not fetch all the rows in the result set.
Find Count	Number of cache hits.
Invalidation Count	Number of cached result sets that got invalidated due to database changes that could have affected the result set.
Delete Count Invalid	Number of cached result rests not invalidated whose memory was reclaimed by result cache.
Delete Count Valid	Number of invalidated cached result rests whose memory was reclaimed by result cache.

分享到：