Release of Oracle Database In-Memory Advisor
By Maria Colgan-Oracle on Feb 23, 2015
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 22.214.171.124 and above, in order to plan your adoption of Oracle Database In-Memory in 126.96.36.199.
Please note the Advisor is licensed as part of the Database Tuning Pack and relies on data coming from the Database Diagnostic Pack.