| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
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 |
