9.89 V$SUBCACHE
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 of the object containing these cache entries |
|
|
Object Name |
|
|
Object Type |
|
|
Heap number containing this subordinate cache |
|
|
Subordinate cache ID |
|
|
Number of entries for this cache in this object |
|
|
Amount of extent space allocated to this heap |
|
|
Amount of extent space allocated from this heap |
|
|
Amount of space utilized in this heap |
|
|
The ID of the container to which the data pertains. Possible values include:
|