image

CHAPTER12

In-Memory Column Store

Purpose

In this chapter, you will learn how to implement Oracle’s new In-Memory Column Store (IMCS). Oracle released this feature in its database version 12.1.0.2. The feature is easy enough to implement; however, its inner workings are not so easy to understand. What’s more, it is vital that you understand the architecture because misuse or misconfiguration of the feature can be disastrous to your database instance.

The IMCS product uses the System Global Area (SGA). It is very tempting to configure IMCS so that it takes up too much of your SGA. Naturally, if this is done, your instance will have difficulty running. ...

Get Oracle Database 12c PL/SQL Advanced Programming Techniques now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.