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: brunors*The views expressed here are my own…
Day: March 21, 2019
[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 brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and…
[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 brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I…