O'Reilly logo

Oracle Database 12c PL/SQL Advanced Programming Techniques by John Harper, Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required