Hello. I have oracle database 12c RAC system with Inmemory option. I took a table to INMEMORY.
select v.owner, v.segment_name, v.bytes orig_size, v.inmemory_size in_mem_size, v.bytes/v.inmemory_size comp_ratio from v$im_segments v;
OWNER
--------------------------------------------------------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
ORIG_SIZE IN_MEM_SIZE COMP_RATIO
---------- ----------- ----------
IMS
VALUES
1943011328 176488448 11.0092833
IMS
VALUES
OWNER
--------------------------------------------------------------------------------
TABLE_NAME
--------------------------------------------------------------------------------
IM IM_PR IM_DIS IM_COMP IM_DUP
-------- -------- --------------- ----------------- -------------
ENABLED CRITICAL AUTO FOR QUERY LOW NO DUPLICATE
We send "select count(*) from ims.values" but it doesn't show any result. I see ony Enterprise Manager, It is on "queue" . What should I do? I waited 20 minutes. Is it reason 'InMemory Enabled' ?
SQL> show parameter inmemory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
inmemory_clause_default string
inmemory_force string DEFAULT
inmemory_max_populate_servers integer 36
inmemory_query string ENABLE
inmemory_size big integer 64G
inmemory_trickle_repopulate_servers_ integer 1
percent
optimizer_inmemory_aware boolean TRUE