V$AUTO_IM_FEATURES

8.77 V$AUTO_IM_FEATURES

V$AUTO_IM_FEATURES describes the In-Memory Column Store performance features that are optimized by Automatic In-Memory (AIM).

Column Datatype Description

Column	Datatype	Description
`FEATURE_ID`	`NUMBER`	Unique feature ID
`DESCRIPTION`	`VARCHAR2(64)`	Feature description. Possible values: `Autonomous` `Bloom` `Filter` `Optimization` `Autonomous` `Join` `Groups` `Autonomous` `Optimized` `Arithmetic` `Autonomous` `Vector` `Optimization`
`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

FEATURE_ID

NUMBER

Unique feature ID

DESCRIPTION

VARCHAR2(64)

Feature description. Possible values:

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 Database 23ai.