Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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 7-6)
VALUE NUMBER Value of the statistic

Table 7-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