5.55 DBA_AIM_PERF_FEATURES

DBA_AIM_PERF_FEATURES describes table columns on which Automatic In-Memory (AIM) performance features are enabled.

Column	Datatype	NULL	Description
OWNER_NAME	VARCHAR2(128)	NOT NULL	Table owner
TABLE_NAME	VARCHAR2(128)	NOT NULL	Table name
COLUMN_NAME	VARCHAR2(128)	NOT NULL	Name of the column on which AIM performance features are enabled
OPTIMIZED_ARITHMETIC	CHAR(1)		Indicates whether the column is optimized for arithmetic operations (Y) or not (N)
BLOOMFILTER_OPTIMIZATION	CHAR(1)		Indicates whether queries on the column use cached hash values to probe the bloom filter during hash joins (Y) or not (N)
VECTOR_OPTIMIZATION	CHAR(1)		Indicates whether data is stored in the column using vector optimization (Y) or not (N)
JOIN_GROUP	CHAR(1)		Indicates whether the column is part of a join group that was created by AIM (Y) or not (N)
CREATION_DATE	DATE		Date and time at which the AIM performance features were implemented

Note:

This view is available starting with Oracle Database 23ai.