Enabling Oracle Database In-Memory (Database In-Memory) option in Oracle Database 12c Release 1

brunors

According to Oracle documentation “Oracle Database In-Memory (Database In-Memory) is a suite of features, first introduced in Oracle Database 12c Release 1 (12.1.0.2), that greatly improves performance for real-time analytics and mixed workloads”. Therefore, in this post I will explain how to enable your Oracle Database to use the In-Memory option :

1- Be sure that your database is running on version level 12.1.0 or higher:


SQL> set pages 2000
SQL> set lines 2000
SQL>  select * from v$version;

BANNER                                             CON_ID

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production          0
PL/SQL Release 12.1.0.2.0 - Production                              0
CORE    12.1.0.2.0  Production                                0
TNS for Linux: Version 12.1.0.2.0 - Production                          0
NLSRTL Version 12.1.0.2.0 - Production                              0

2- Set the parameter INMEMORY_SIZE to any value at about 100M (minimum setting):


SQL> show parameters  INMEMORY_SIZE

NAME                     TYPE    VALUE

inmemory_size                 big integer 0
SQL>  alter system set inmemory_size=200M scope=spfile;

System altered.

3- Restart the database:


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  486539264 bytes
Fixed Size            2925792 bytes
Variable Size          218106656 bytes
Database Buffers       50331648 bytes
Redo Buffers            5459968 bytes
In-Memory Area          209715200 bytes
Database mounted.
Database opened.
SQL> show parameters  INMEMORY_SIZE

NAME                     TYPE    VALUE
inmemory_size                 big integer 200M

Related posts

Leave a Comment