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

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: 2- Set the parameter INMEMORY_SIZE to any value at about 100M (minimum setting): 3- Restart the database: brunorsHi! I am Bruno, a Brazilian born…

[OCM 12C] Tuning SQL statements

DBMS_STATS.CREATE_EXTENDED_STATSDBMS_STATS.GATHER_TABLE_STATS PARAMETER OPTIMIZER_MODE Database SQL Tuning Guide -> 14 Influencing the Optimizer brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely…

[OCM 12C] Managing SQL Plan Baselines

“SQL plan management is a preventative mechanism that enables the optimizer to automatically manage execution plans, ensuring that the database uses only known or verified plans.” SPM has three main components: • Plan Capture: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES = TRUE (Automatic Initial Plan Capture), OPTIMIZER_USE_SQL_PLAN_BASELINE=TRUE • Plan Selection • Plan Verification/Evolution dba_sql_plan_baselines DBA_SQL_PLAN_BASELINE Database Administration -> Database SQL Tuning Guide -> 23 Managing SQL Plan Baselines brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up…