10.154 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.