Oracle Database In-Memory Advisor

Recently, Oracle announced the general availability of the Oracle Database In-Memory Advisor—a new capability built into Oracle Enterprise Manager 12c Tuning Pack. With this release, Oracle introduces new and extensive capabilities for managing Oracle Database In-Memory, an Oracle Database 12c Enterprise Edition option.

Oracle Database In-Memory can be used to improve queries on a variety of OLTP and/or data warehouse operations. The In-Memory Advisor helps to optimize performance with recommendations to run analytics processing faster. It gives customers insight into the sizing of the workload and offers actionable recommendations for running workloads at peak performance. The Advisor analyzes workloads and related objects making specific recommendations to which objects would give you the greatest benefit and performance if they were placed In-Memory.

Key Capabilities:

  • Assists with In-Memory size selection
  • Recommendations for tables, partitions and sub-partitions for a given In-Memory size
  • Uses workload and performance data to prioritize objects
  • Takes into account differences in disk and memory footprint, as well as compression ratios

Actionable Recommendations

  • Workload based cost/benefit analysis
    • Cost: Offers estimated memory size with various compression options
    • Benefit: Offers estimated database time reduction metrics for workload processing
  • In-memory area population plan

Reporting

  • Ability to vary In-Memory size to receive specific loading plan
  • Generates DDL scripts with all the tables/partitions/sub-partitions recommended
  • Top SQL benefits from any given configuration

For more information, visit the Oracle Database In-Memory Advisor page on the Oracle Technology Network. You can download the In-Memory Advisor, via MOS note 1965343.1.


Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Latest information on Oracle Enterprise Manager and Oracle Management Cloud.

Related Blogs




Search


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