Oracle Database In-Memory option was released with Oracle Database 12c (220.127.116.11) and the In-Memory Advisor (IMA) has been much awaited since then. The Oracle Database In-Memory is designed to achieve the following goals:
- Speed up analytical queries
- Speed up OLTP transactions
- NO application changes
Without the In-Memory Advisor, a DBA has to manually identify the tables to be placed in the In-Memory Column Store (IMCS). This manual task is no more required as the IMA, analyzes the analytical workload of the database and produces a recommendation report (which includes SQL commands to place the tables in IMCS).
For more information on IMA please refer to MOS: 1965343.1 and you may also download the best practices white paper from here.