INMEMORY IN ORACLE 12C

IN Memory

inmemory_size must be set 100m or larger

sga_target=sga+in memory ---singe instance

sga_targer=sga+(inmemory*1)--Rac

pga_target= (max expected parallel servers * 2gb)


how does it work


SGA_TARGET must be large enough to accommodate in memory area.

Contain data in the new in memory columnar format.

inmemory contain two subpools

imcu  allocate 1mb extend in memory area(segements)

smu

object in memory area is composed of one or more

some useful for immemory.

V$inmemory_area current size of pools in the in memory area

v$IM_SEGMENTS  list of segments currently populated in memory column store.

to monitor the progress of population.

V$INMEMORY_AREA ---IS THERE ENOUGH MEMORY

V$IM_SEGMENTS
V$IM_SMU_HEAD




Inmemory column store is not a cache

Any objects with the in memory




oracle -in-memory advisor
===================