Kayshav.com
About Developer Oracle 12c Oracle 19c Technology Information Sitemap

Oracle In Memory Feature
-- 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
;



   Oracle 12c Table Enhancements    InMemory Table    SGA Queries

   Oracle 12c Index

Oracle registered trademark of Oracle Corporation.

Last Revised On: June 27th, 2020

  2327