Dynamic Performance (V$) Views, 160 of 179

V$SUBCACHE

This view 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 object containing these cache entries

NAME

VARCHAR2(1000)

Object Name

TYPE

NUMBER

Object Type

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

Column	Datatype	Description
`OWNER_NAME`	`VARCHAR2(64)`	Owner of object containing these cache entries
`NAME`	`VARCHAR2(1000)`	Object Name
`TYPE`	`NUMBER`	Object Type
`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