How to set up data collection from INMEMORY in Oracle 12c?

Question

Oracle

I have a database where several tables need to be quickly accessed. I upload them to the INMEMORYsection

ALTER TABLE %table_name% PRIORITY CRITICAL MEMCOMPRESS FOR DML;

When trying to check whether data will be taken from inmemory through SELECT * from %table_name%Autotrace, it reports that all data is taken from the main memory. What am I doing wrong?

Answer 1

See V$IM_SEGMENTS