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 |