Today Oracle released the new Oracle Database In-Memory Advisor (In-Memory Advisor). The goal of this advisor is to identify analytic workloads that will benefit from Oracle Database In-Memory.
The In-Memory Advisor identifies analytic workloads by analyzing Active Session History (ASH) and AWR data. It differentiates analytic processing from other database activity, based upon SQL plan cardinality, use of parallel query, and other statistics.
The Advisor produces a report identifying the objects that should be
placed In-Memory for maximum benefit, along with a SQL*PLUS script which
implements those recommendations. It also estimates the size of the objects in the In-Memory column store based upon statistics and heuristic compression factors.
The Advisor can be run on Oracle Database 18.104.22.168 and above, in order to plan your adoption of Oracle Database In-Memory in 22.214.171.124.
Please note the Advisor is licensed as part of the Database Tuning Pack and relies on data coming from the Database Diagnostic Pack.