9.6 V$INMEMORY_AREA
V$INMEMORY_AREA
contains information on the space allocation inside the In-Memory Area.
The In-Memory Area is sub-divided into three pools:
-
1MB
POOL
- stores the actual column formatted data populated into memory -
64K
POOL
- stores metadata about the objects that are populated into the In-Memory Column Store (IM column store) -
IM
POOL
METADATA
- contains information about In-Memory Compression Unit (IMCU) to data block mappings
The amount of available memory in each pool is visible in the V$INMEMORY_AREA
view. The relative size of the three pools is determined by internal heuristics. The majority of the In-Memory Area memory is allocated to the 1MB
POOL
Column | Datatype | Description |
---|---|---|
|
|
Name of the pools in the In-Memory Area |
|
|
Total amount of memory allocated to this pool |
|
|
Amount of memory currently used in this pool |
|
|
Shows the status of the IM column store, for example, whether it is currently being populated or if it is done |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
-
Oracle Database In-Memory Guide for an introduction to the IM column store