Oracle Database 18.104.22.168 introduced Oracle Database In-Memory allowing a single database to efficiently support mixed analytic and transactional workloads.
New! Oracle Database In-Memory Advisor new version released. Further details below.
Oracle Database 22.214.171.124 introduced Oracle Database In-Memory allowing a single database to efficiently support mixed analytic and transactional workloads. An Oracle Database configured with Database In-Memory delivers optimal performance for transactions while simultaneously supporting real-time analytics and reporting.
For complete details about Oracle Database In-Memory, see the Oracle Database In-Memory pageon oracle.com.
Oracle Database In-Memory is designed to optimize analytical processing in the database. The In-Memory Advisor analyzes the analytical processing workload present in your database to determine an estimated benefit for the database as a whole if that analytical workload is optimized.
The In-Memory Advisor differentiates analytics processing from other database activity based upon SQL plan cardinality, Active Session History (ASH), use of parallel query, and other statistics.
The In-Memory Advisor estimates the In-Memory size of objects based upon statistics and heuristic compression factors.
The In-Memory Advisor estimates analytic processing performance improvement factors based upon the following:
The Advisor produces a recommendation report. The report lists a number of In-Memory sizes with estimated performance benefits, lists the objects which should be placed in the In-Memory column store for a given In-Memory size and the recommended compression factor for those objects. It also produces a SQLPLUS script to modify the objects to place them In-Memory.
For information on obtaining the Advisor, please refer to My Oracle Support (MOS) note 1965343.1.
The updates to the Advisor include: