On the Ninth Day of 12.2, my DBA gave to me… In-Memory New Features


In-Memory Expressions

An In-memory expression, or 'hot' expression, enables frequently evaluated query expressions to be materialized in the In-Memory Column Store, for subsequent reuse. By default, the procedure DBMS_INMEMORY_ADMIN.IME_CAPTURE_EXPRESSIONS identifies and populates IM expressions. Populating the materialized values of frequently used query expressions, into the In-Memory Column Store, greatly reduces the system resources required to execute queries, allowing for better scalability. The procedure, IME_CAPTURE_EXPRESSIONS, will capture and populate the 20 'hottest' expressions in the database for a specified time range.

In-Memory Virtual Columns

An IM virtual column, is a value derived by evaluating an expression. IM virtual columns improve query performance by avoiding repeated calculations. Also, the database can scan and filter IM virtual columns, using techniques such as SIMD vector processing.

In-Memory FastStart

Before 12.2, the columnar format was only available In-Memory, meaning that after a database restart, the In-Memory Column Store would have to be populated. This multiple step process, converted traditional, row formatted data into the compressed columnar format and placed in-memory. Now, In-Memory Column Store optimizes the compressed columnar population of database objects (tables, partitions, and subpartitions) in the…


To receive a full version copy of this document via email, including more on Automatic Data Optimization (ADO) Support for In-Memory Column Store, In-Memory Join Groups, In-Memory Support on Oracle Active Data Guard, and In-Memory Column Store Dynamic Resizing, please complete the download form provided. 

Complete this form for an auto-emailed full version copy:

Full Name (required)

Your Email (required)

Company (required)

Phone number (required)

Job Title (required)