Hi,
i have been enabled inmemory in 18c oracle DB,
and enabled 2 tablespaces inmemory feature.
but check v$inmemory_area there are 0 in_use size.
anything i missed ?
thanks.
FYI:
SQL> show parameter inmemory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
inmemory_adg_enabled boolean TRUE
inmemory_automatic_level string OFF
inmemory_clause_default string
inmemory_expressions_usage string ENABLE
inmemory_force string DEFAULT
inmemory_max_populate_servers integer 8
inmemory_optimized_arithmetic string DISABLE
inmemory_prefer_xmem_memcompress string
inmemory_prefer_xmem_priority string
inmemory_query string ENABLE
inmemory_size big integer 20G
inmemory_trickle_repopulate_servers_ integer 1
percent
inmemory_virtual_columns string MANUAL
inmemory_xmem_size big integer 0
optimizer_inmemory_aware boolean TRUE
SYS@bidev> select DEF_INMEMORY,DEF_INMEMORY_PRIORITY,DEF_INMEMORY_DISTRIBUTE,DEF_INMEMORY_COMPRESSION,DEF_INMEMORY_DUPLICATE,TABLESPACE_NAME from dba_tablespaces;
DEF_INME DEF_INME DEF_INMEMORY_DI DEF_INMEMORY_COMP DEF_INMEMORY_ TABLESPACE_NAME
-------- -------- --------------- ----------------- ------------- ------------------------------
DISABLED SYSTEM
DISABLED SYSAUX
DISABLED UNDOTBS1
DISABLED TEMP
DISABLED USERS
DISABLED AUDTRAIL
ENABLED NONE AUTO FOR QUERY LOW NO DUPLICATE ESS_BI
ENABLED NONE AUTO FOR QUERY LOW NO DUPLICATE ESS_BI_IDX
DISABLED SYSAUDIT_IDX
DISABLED SYSAUDIT
> select sum(INMEMORY_SIZE/1024/1024) IN_MB, sum(BYTES/1024/1024) SEG_MB from v$im_segments;
IN_MB SEG_MB
---------- ----------
> select ALLOC_BYTES/1024/1024 alloc_MB, USED_BYTES/1024/1024 used_MB, POOL, POPULATE_STATUS from v$inmemory_area;
ALLOC_MB USED_MB POOL POPULATE_STATUS
---------- ---------- -------------------------- --------------------------
14067 0 1MB POOL DONE
6125.4375 0 64KB POOL DONE