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 unless the memory block is allocated to a cache object (FREE = NO)
POSITION NUMBER Position of the block in the cached object; NULL unless the memory block is allocated to a cache object (FREE = NO)