V$VECTOR_MEMORY_POOL
This view contains information about the space allocation for Vector Memory.
The Vector Memory Pool area is used primarily to maintain in-memory vector indexes or
metadata useful for vector-related operations. The Vector Memory Pool is subdivided
into two pools: a 1MB pool used to store In-Memory Neighbor Graph Index allocations;
and a 64K pool used to store metadata. The amount of available memory in each pool
is visible in the V$VECTOR_MEMORY_POOL view. The relative size of
the two pools is determined by internal heuristics. The size of the Vector Memory
Pool is controlled by the vector_memory_size
parameter. Area in the Vector Memory Pool is also allocated to accelerate Neighbor
Partition Index access by storing centroid vectors.
| Column Name | Data Type | Description |
|---|---|---|
|
|
|
Name of the pools in the Vector Memory Pool (64K or 1MB) |
|
|
|
Total amount of memory allocated to this pool |
|
|
|
Amount of memory currently used in this pool |
|
|
|
Status of the vector memory store—whether it is being populated, is done populating etc. |
|
|
|
The ID of the container to which the data pertains. Possible values are:
|
Example
select CON_ID, POOL, ALLOC_BYTES/1024/1024 as ALLOC_BYTES_MB,
USED_BYTES/1024/1024 as USED_BYTES_MB
from V$VECTOR_MEMORY_POOL order by 1,2;
CON_ID POOL ALLOC_BYTES_MB USED_BYTES_MB
---------- ---------------- -------------- -------------
1 1MB POOL 319 0
1 64KB POOL 144 0
1 IM POOL METADATA 32 32
2 1MB POOL 320 0
2 64KB POOL 144 0
2 IM POOL METADATA 16 16
3 1MB POOL 320 0
3 64KB POOL 144 0
3 IM POOL METADATA 16 16
4 1MB POOL 320 0
4 64KB POOL 144 0
4 IM POOL METADATA 16 16
12 rows selected.
SQL>Parent topic: Vector Memory Pool Views