V$SUBCACHE displays information about the subordinate caches currently loaded into library cache memory. The view walks through the library cache, printing out a row for each loaded subordinate cache per library cache object.

Column Datatype Description
OWNER_NAME VARCHAR2(64) Owner of the object containing these cache entries
NAME VARCHAR2(1000) Object Name
HEAP_NUM NUMBER Heap number containing this subordinate cache
CACHE_ID NUMBER Subordinate cache ID
CACHE_CNT NUMBER Number of entries for this cache in this object
HEAP_SZ NUMBER Amount of extent space allocated to this heap
HEAP_ALOC NUMBER Amount of extent space allocated from this heap
HEAP_USED NUMBER Amount of space utilized in this heap