Oracle Database 12c DBA Handbook

CHAPTER9

In-Memory Option

In Chapter 8, we talked about tuning methodologies and other ways to maximize throughput and minimize response time. One of the most useful and powerful new features of Oracle Database 12c, the In-Memory option (available starting with version 12.1.0.2), adds another tool you can use to make your queries run faster than ever before.

This chapter gives a high-level overview of the Oracle In-Memory option, what system requirements you need to use it effectively, and what it can and cannot do. I’ll give a few real-world examples of how In-Memory works and review the dynamic performance views you need to use to identify ...