{15 その他}表の列に対しインメモリー列ストアを有効化

 

https://docs.oracle.com/cd/F19136_01/inmem/populating-objects-in-memory.html#GUID-452D19AE-EB5F-44AC-A1AD-70CF10D2D347

sqlplus test/test@pdb11

ALTER TABLE SH.CHANNELS  
   INMEMORY MEMCOMPRESS FOR QUERY (
      CHANNEL_ID, CHANNEL_DESC )
   INMEMORY MEMCOMPRESS FOR CAPACITY HIGH (
      CHANNEL_CLASS, CHANNEL_CLASS_ID )
   NO INMEMORY (
      CHANNEL_TOTAL, CHANNEL_TOTAL_ID );

COL TABLE_NAME FORMAT a20
COL COLUMN_NAME FORMAT a20

SELECT TABLE_NAME, COLUMN_NAME, INMEMORY_COMPRESSION 
FROM   V$IM_COLUMN_LEVEL 
;

SELECT OWNER,TABLE_NAME,INMEMORY,INMEMORY_PRIORITY,INMEMORY_COMPRESSION
FROM DBA_TABLES
WHERE INMEMORY = 'ENABLED'
;

SELECT OWNER, SEGMENT_NAME, INMEMORY_PRIORITY, INMEMORY_COMPRESSION 
   FROM V$IM_SEGMENTS;