Alle CursussenbalkjeAlgemeen Introductie HW & SW Soft skills TrajectenOperating Systems MVS - z/OS UNIX - Linux - AIX Mac OS X iPad en iPhone iOSDatabases en middleware Relationele databases & SQL DB2 for z/OS DB2 for LUW Oracle SQL Server MySQL & MariaDB IMS CICS IBM MQ WebSphere Big data en analyticsApplicatieontwikkeling Methoden en technieken TOGAF PRINCE2 Agile en Scrum Programmeertalen Internet development Object Oriented systems Java Development tools SAS XML SOA & web servicesSysteembeheer ITIL SecuritybalkjePraktischInschrijven 
Deze pagina is niet beschikbaar in het Nederlands.
Columnar storage: Oracle 12c In-Memory database


During this course participants learn about one of the two most challenging new features of Oracle 12c - the In-Memory Database Option. Or more specifically: how to turn your 'traditional' Oracle database environment into a columnar data store ready for big data workloads.

At the end of this course, participants will be able to:

  • identify the core characteristics of the Oracle In-Memory database option
  • setup, monitor and administer Oracle columnar databases
  • advice application developers - and others - on its usefulness within an Oracle context


Main topics

  • Introduction: the concepts and theories behind columnar databases
  • The Oracle point-of-view: the In-Memory Database Option concepts

Introduction and Architecture

  • The In-Memory Database Option

Concepts - setup of the architecture - initialization parameters - row versus column format - the in-memory concept

Monitoring the In-Memory Database Option

  • DML and the In-Memory Database Option / Columnar Datastore

Data manipulation (scans, joins, aggregation) - Data loads - Partitioning - Hints


  • Use cases

Intended for

Experienced Oracle DBAs who need to setup, configure and manage the In-Memory Database Option.


Knowledge of Oracle - level Oracle Database Administration - is required.

Training method

This is mainly a conceptual course. After a short theoretical introduction, some time is spent on the set-up and use in a theoretical context.

Course leader

Kris Van Thillo, Sandy Schillebeeckx.


1 day.


Momenteel zijn er voor deze cursus geen publieke sessies gepland. Graag organiseren we een bedrijfssessie voor u of een extra publieke sessie (bij voldoende belangstelling). Geïnteresseerd ? Gelieve dan ABIS te contacteren.