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`	`NUMBER`	Value of the statistic

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