V$VECTOR_MEMORY_POOL

V$VECTOR_MEMORY_POOL displays information about space allocation for the Vector Pool.

The Vector Pool is divided into two pools: a 1 MB pool used to store In-Memory Neighbor Graph Index allocations and a 64 KB pool used to store metadata. This view displays the amount of available memory in each pool.

Column Datatype Description
POOL VARCHAR2(26) Name of the pool
ALLOC_BYTES NUMBER Total amount of memory (in bytes) allocated to the pool
USED_BYTES NUMBER Amount of memory (in bytes) currently used in the pool
POPULATE_STATUS VARCHAR2(26) Status of populating the pool
CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Note: This view is available starting with Oracle AI Database 26ai.