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
Hi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)