With INMEMORY_SIZE 0, IN-MEMORY option is reported as USED (Doc ID 1924832.1)

Last updated on DECEMBER 25, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2016***

Symptoms

Example to illustrate the behaviour:
SQL> show parameters compatible

NAME TYPE VALUE
------------------------------------ -----------

compatible string 12.1.0.0

noncdb_compatible boolean FALSE

SQL> show parameters inmemory_size

NAME TYPE VALUE

------------------------------------ -----------
inmemory_size big integer 0

SQL> select name,currently_used from dba_feature_usage_statistics
2 where name like '%In-Memory%' ;

NAME CURRE
---------------------------------------- -----
In-Memory Column Store FALSE
In-Memory Aggregation FALSE

SQL> CREATE TABLE t1 (a number, b char(1000),
2 c char(1000), d varchar(1000),
3 e varchar(1000)) inmemory ;

Table created.

SQL> execute dbms_lock.sleep(30) ;

PL/SQL procedure successfully completed.

SQL> alter session set events 'immediate trace name mmon_test level 6' ;

Session altered.

SQL> select name,currently_used from dba_feature_usage_statistics
2 where name like '%In-Memory%' ;

NAME CURRE
---------------------------------------- -----
In-Memory Column Store TRUE

This is not expected bahaviour,it sould be FALSE as INMEMORY_SIZE 0 is 0

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms