Release of Oracle Database In-Memory Advisor

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.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

The Oracle Database In-Memory blog is written by the Oracle product management team and sheds light on all things In-Memory.

Search


Archives
« March 2017
SunMonTueWedThuFriSat
   
1
3
4
5
6
7
8
9
10
11
12
14
15
16
17
18
19
20
23
24
25
26
27
28
29
30
31
 
       
Today