-- Oracle database In-Memory Column Store is a new feature of 
-- SGA and known as In-Memory Area.

-- To check the in memory parameter

show parameter inmemory

-- Enable In-Memory feature

alter system set inmemory_size=5G scope=spfile;

shutdown immediate;

startup

show parameter inmemory_size


SELECT name ,value 
FROM  v$sga 
WHERE name='In-Memory Area'
;

-- Tablespace altered to be In Memory
 
ALTER TABLESPACE tablespace_name DEFAULT INMEMORY
;


SELECT * FROM  v$im_column_level
;


SELECT owner, segment_name, populate_status 
FROM   v$im_segments
;


SELECT * FROM  v$im_segments_details
;