Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-12
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
PDF · Mobi · ePub

V$RESULT_CACHE_MEMORY

V$RESULT_CACHE_MEMORY displays all the memory blocks and their status.

Column Datatype Description
ID NUMBER Unique block identifier (that is, the block number)
CHUNK NUMBER Chunk to which the block belongs (the upper 27 bits of the ID)
OFFSET NUMBER Offset of the block within its chunk (the lower 5 bits of the ID)
FREE VARCHAR2(3) Indicates whether the block is free (YES) or not (NO)
OBJECT_ID NUMBER Cache object to which the memory block belongs; NULL if the memory block is not allocated to a cache object (FREE = YES)
POSITION NUMBER Position of the block in the cached object; NULL if the memory block is not allocated to a cache object (FREE = YES)