X

Enabling Real-Time Analytics With Database In-Memory

Release of Oracle Database In-Memory Advisor

By: Maria Colgan | Master Product Manager

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 11.2.0.3 and above, in order to plan your adoption of Oracle Database In-Memory in 12.1.0.2.

Please note the Advisor is licensed as part of the Database Tuning Pack and relies on data coming from the Database Diagnostic Pack.

You can download the Advisor, via MOS note 1965343.1. Additional information about the Advisor can be found on Oracle.com.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services