8.171 V$RESULT_CACHE_STATISTICS

V$RESULT_CACHE_STATISTICS displays various Result Cache settings and usage statistics.

Column	Datatype	Description
ID	NUMBER	Statistic number
NAME	VARCHAR2(128)	Name of the statistic (see Table 8-6)
VALUE	VARCHAR2(81)	Value of the statistic
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

Table 8-6 V$RESULT_CACHE_STATISTICS Statistics

Statistic Name	Description
Block Size (Bytes)	Size of each memory block
Block Count Maximum	Maximum number of memory blocks allowed
Block Count Current	Number of memory blocks currently allocated
Result Size Maximum (Blocks)	Maximum number of blocks allowed for a single result
Create Count Success	Number of cache results successfully created
Create Count Failure	Number of cache results that failed to create
Find Count	Number of cached results that were successfully found
Invalidation Count	Total number of invalidations
Delete Count Invalid	Number of invalid cached results deleted
Delete Count Valid	Number of valid cached results deleted
Hash Chain Length	Average length of items in the hash chain
Find Copy Count	Number of results copied directly out of the cache